|
|
| Re: Urgent ...... ORA-01002. Fetch Out of sequence [message #369501 is a reply to message #369499] |
Tue, 10 October 2000 12:38  |
Christian Boulet
Messages: 9
Registered: April 2000
|
Junior Member |
|
|
Cause: This error means that a fetch has been attempted from a cursor which is no longer valid. Note that a PL/SQL cursor loop implicitly does fetches, and thus may also cause this error.
There are a number of possible causes for this error, including:
1) Fetching from a cursor after the last row has been retrieved
and the ORA-1403 error returned.
2) If the cursor has been opened with the FOR UPDATE clause,
fetching after a COMMIT has been issued will return the error.
3) Rebinding any placeholders in the SQL statement, then issuing
a fetch before reexecuting the statement.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
