Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> fetch across commit

fetch across commit

From: z b <zimsbait_at_gmail.com>
Date: Wed, 24 Nov 2004 12:54:12 -0500
Message-ID: <5b1f2b70041124095415ec3b7d@mail.gmail.com>


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-l
Received on Wed Nov 24 2004 - 11:53:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US