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

I have thrown away the hardcopy manual. So here is from the Documentation CD :-

ORA-01002: fetch out of sequence

Cause: In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This can occur if an attempt was made to FETCH from an active set after all records have been fetched. This may be caused by fetching from a SELECT FOR UPDATE cursor after a commit. A PL/SQL cursor loop
implicitly does fetches and may also cause this error.

Action: Parse and execute a SQL statement before attempting to fetch the data.

Looks like you might have to look at the stored procedure code.

rgds
Joseph

kimathi_at_my-deja.com wrote:

> I get the following error from a stored procedure call.
> Any hints what may be wrong?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jul 06 2000 - 00:00:00 CDT