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

Home -> Community -> Usenet -> c.d.o.server -> Re: PLSQL Error: ORA-01002: fetch out of sequence

Re: PLSQL Error: ORA-01002: fetch out of sequence

From: D Hauser <david.hauser_at_ualberta.ca>
Date: Tue, 09 Nov 1999 14:37:46 -0700
Message-ID: <3828942A.87EF52F4@ualberta.ca>


Hi there,

I GOT IT. It looks like I was using savepoint incorrectly. All DB writes have implicit SPs and so I was explicitly setting a SP where none was required...

Thanks for the help.

TurkBear wrote:

> Without seeing the actual code for the procedure, this is only a general
> response:
>
> The most common reason for this error is the cursor being closed and then
> another fetch being issued - check your code for nested loops and be sure the
> close cursor ( explicit and implicit ) instructions are properly 'scoped' - that
> is they operate in the correct sequence ( even when exceptions are raised in one
> of the loops...)
>
> hth,
> John Greco
>
>
Received on Tue Nov 09 1999 - 15:37:46 CST

Original text of this message

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