ORA-01002: fetch out of sequence
Answer / guest
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.
Action: 1) Do not issue a fetch statement after the last row
has been retrieved - there are no more rows to fetch. 2) Do
not issue a COMMIT inside a fetch loop for a cursor that has
been opened FOR UPDATE. 3) Reexecute the statement after
rebinding, then attempt to fetch again.
Please add more information about this Error
Is This Answer Correct ? | 0 Yes | 0 No |
SQL*Loader-00121: Invalid skip_unusable_indexes option
ORA-29294: A data error occurred during compression or uncompression.
PLS-00204: function or pseudo-column 'string' may be used inside a SQL statement only
ORA-30100: internal error [number]
ORA-07619: $IDTOASC failed translating an integrity level
ORA-00335: online log string: No log with this number, log does not exist
ORA-25285: Invalid value string for array_mode
ORA-30653: reject limit reached
ORA-28545: error diagnosed by Net8 when connecting to an agent
ORA-03008: parameter COMPATIBLE >= string needed for string
ORA-28520: error initializing heterogeneous data dictionary translations
ORA-22627: tc [string] must be that of object/varray/nested table