Oracle-L: Re: Fetch Out of Sequence Error

From: Pratap Singh <singhp_at_BACTC.COM>
Date: Tue, 23 Jan 1996 12:33:47 PST
Message-Id: <9601232038.AA31787@alice.jcc.com>

At 02:27 PM 1/23/96 +0800, you wrote:
>We encounter a error ORA-01002 Fetch out of sequence error in a PL/SQL
>program. In this program, we have a cursor loop and perform lots of
>updating. So we need to commit the transaction.
>
>Could anybody can help me.
>

If you are having any cursor with FOR UPDATE then you can not do comit. You may try using cursor without for update clause and make use of rowid for getting performance similar to FOR UPDATE/WHERE CURRENT OF

HTH Pratap

Pratap Singh

Email: singhp_at_bactc.com
Voice: 415-827-5868
Fax: 415-266-6324

We are free to choose what we will do, think, say, be, but we are not free to choose the consequences of those choices.

Received on Tue Jan 23 1996 - 15:38:17 CST