Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PLSQL Error: ORA-01002: fetch out of sequence
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