title: Procedure: commit after 10000 records
body: <pre><code>CREATE OR REPLACE PROCEDURE testing AS
  BEGIN
  
      insert into t3 select * from t2;
  
      insert into t1 select * from t4;
  
  commit;
  EXCEPTION WHEN OTHER THEN
       ROLLBACK;
  END;
  </code></pre>
  
  <p>This will work fine</p>
  
  <p>t2 - 3 millions
  t4 - 3 millions
  total i have 6 million record , due some reason my temp space gets filled so what i want is to commit after every 10000 record is inserted .</p>
  
  <p>how to do? </p>