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) ;