Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> fetch across commit
Listers,
I have a question where I need a little clarification about fetching across commits. Can this happen if the table being committed to is not the same as the tables(s) in the cursors?
For example, if I had :
cursor c1 is select empname form emp where
dept = 100;
open c1
loop
fetch c1 into var;
exit when c1%notfound
insert into table some_temp_table;
commit;
end loop
close c1
I have a hunch this is causing 1555's for us. Thanks in advance for input.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 24 2004 - 11:53:05 CST