Can network problems cause an ORA-01002 fetch out of sequence error?
A sql statement intermittently keeps getting an ORA-1002 fetch out of sequence error. I have informed the developers the possible causes, but he insists its a network problem that is causing this as elsewhere this works fine. Could this error be caused by a faulty network?
The error resides between the chair and the keyboard
Definitely not, it's a programming error:
Quote:
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.
:p
