Re: Help:Snapshot too old

Our PL/SQL is very simple

Declare
Cursor A is
[Quoted] select * from table B;

Begin

For C in A loop
v_counter=v_counter+1;
[Quoted] insert into table D values ....
if mod(v_counter,2000)=0 then
commit;
end if;
end loop;
end;

But we always get error message says
snapshot too old. I even tried commit
every 5 rows, I still have the same problem. If we try to commit every 20,000 rows, we will have problem until 800,000 rows was inserted.

Any suggestions?

Thanks  

-- 
Sent by dbadba62  from  hotmail in area com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new