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

This error can occur if you are using a combination of

1. Setting transaction to use specific rollback segment
2. Committing within loop
3. Performing Update where current of

Gary.
Joseph Li <lijoecyn_at_netspace.net.au> wrote in message news:3964EEEB.9A393A6F_at_netspace.net.au...
> 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 Fri Jul 07 2000 - 00:00:00 CDT