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

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL Question

PL/SQL Question

From: <amerar_at_unsu.com>
Date: Sat, 01 Apr 2000 09:03:00 GMT
Message-ID: <8c4dvu$vl6$1@nnrp1.deja.com> 







Hi there,



I have a cursor FOR loop that will update over 1 million records.  The cursor
is defined with the FOR UPDATE clause.	I have a counter that commits after
every 10000, however when running the program I got this error:



ORA-01002:  Fetch out of sequence



What does this mean?  Can't I commit within a cursor FOR loop?



Thanks,



Arthur


amerar_at_unsu.com




Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Sat Apr 01 2000 - 03:03:00 CST












Original text of this message













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