This content has been marked as final. Show 1 reply
Aviral wrote:Did you test that procedure first? It has an infinite loop. If it's running, it's inserting row after row into the table, but never COMMITting, because it never leaves the loop.
create or replace procedure sp_test is
insert into test values(seq_test.nextval) ;
It looks like what you posted is a much simplified version of what you're really doing. Simplifying things for posting on this forum is a good idea, but this one is so simplified that I can't see the point of it, so I can't suggest a better way to do it. Maybe you shouldn't have a loop in the procedure. Whatever you do, test it before submitting it as a job.