fetch across commit

From: z b <zimsbait@xxxxxxxxx>
To: Oracle List <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 24 Nov 2004 12:54:12 -0500

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.
--
//www.freelists.org/webpage/oracle-l

fetch across commit

Other related posts: