Re: PL/SQL Question

From: John Gasch <jgasch_at_erols.com>
Date: 2000/04/02
Message-ID: <38E79F58.4900C29A@erols.com>#1/1

The FOR UPDATE locked all of the rows matching your SELECT statement. COMMIT released the locks and ended the transaction. You can commit within the loop if you don't use FOR UPDATE, but you must take care in a concurrent environment if there's any chance of another process changing something on you.

G'day

John Gasch

amerar_at_unsu.com wrote:
>
> 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 Sun Apr 02 2000 - 00:00:00 CST