Re: PL/SQL Question

A commit closes all cursors,
Hence you cannot commit inside a cursor for loop. The only solution is to enlarge your rollback segments.

Hth,
Sybrand Bakker, Oracle DBA

<amerar_at_unsu.com> wrote in message news:8c4e1l$vl7$1_at_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 - 00:00:00 CST