Try:
insert into EMP values (emp_seq.nextval, ....);
commit;
I have read on this board that selecting the next sequence value from dual can leave open cursors.
Good luck.
|
Results 1 to 4 of 4
Threaded View
|
Click Here to Expand Forum to Full Width |