title: how to schedule a procedure in oracle 10g?
body: <p>i have to schedule a stored procedure in oracle 10g?</p>
  
  <p>assume</p>
  
  <pre><code>create table t1(name varchar2(10));
  insert into t1 values('hi');
  
  create or replace procedure insertname
  as
  begin
  insert into t1 values('hi');
  end;
  </code></pre>
  
  <p>now my requirement is everday at 11 am my procedure has to be executed automatically.</p>
  
  <p>how can i implement it.</p>
  
  <p>actually i studied about dbms_scheduler.create_job. but i am not able to implement it can any body explain me how can i schedule my stored procedure.</p>
  
  <p>thanks in advance</p>