ORA-01002: fetch out of sequence
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.
ORA-01010
Custom Search


More Oracle errors
OCI-22604TDS handle already generated
SQL*Loader-00560error reading file
ORA-02254DEFAULT <expression> not allowed here
ORA-00489ARB* process terminated with error
AMD-00146Custom Measure "string" already exists in Workspace "string"
TNS-00125Failed to get number of Interchanges in TNSNET.ORA
PLS-01503The expression in a SET clause must not include a set function
ORA-37070You may not execute OLAP DML programs in a parallel query session.
ORA-38429invalid datatype for a stored attribute: string
PGA-20936send buffer length is number but no send lengths were specified
PLS-00509Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field
RMAN-06935Convert script name too long
EXP-00020failed to allocate memory of size number
ORA-24063cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
SQL*Loader-00563bad length for VAR record
PGU-41119expecting one of DATA, CALL, or TRANSACTION in a DEFINE
ORA-37075(XSMCSESS03) You cannot rename a session-only dimension value.
ORA-01308initialization parameter utl_file_dir is not set
ORA-09777osnpbr: cannot send break message
ORA-31110Action failed as resource string is locked by name




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
ORA-01002fetch out of sequence