Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> "Fetch out of Sequence" error message
A SQL*Plus script that has run perfectly every day for 2 years suddenly came back with ORA-01002. The official description is below:
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.
Any ideas what might cause this or how to fix so that it can't happen again?
TIA Ian Brown Received on Sun Jul 22 2001 - 04:28:30 CDT