Re: Help: ERROR ORA01002: Fetch out of sequence.

From: Peter-Paul van de Beek <P.P.v.d.Beek_at_a2000.com>
Date: Mon, 30 Nov 1998 15:34:15 +0100
Message-ID: <3662ACE7.713D902D@a2000.com>

Abraham,

There probably something wrong in your cursor handling, eg is there a commit while your using a select for update cursor? More info is required about the PL/SQL block for a more detailed answer.

Good luck,
Peter-Paul

Abraham Zhang wrote:

> I wrote a PL/SQL block dealing with the cursor stuff via sqlplus. It
> works only good for the first 3 or 5 times, and then it hit 'ERROR
> ORA01002: Fetch out of sequence.' error. If any person could help me
> out. Thanks a lot.
>
> --
> Good Luck!
>
> Abraham Zhang
>
> Telephone: (403)-220-5444
> Fax: (403)-282-9361
> E-mail: azhan_at_ucalgary.ca
> Web Site: http://www.acs.ucalgary.ca/~azhan/
Received on Mon Nov 30 1998 - 08:34:15 CST