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
ORA-07262sptpa: sptpa called with invalid process id.
ORA-01554out of transaction slots in transaction tables
LCD-00203missing keyword [string]
DRG-51025an invalid character was passed to the stemmer
RMAN-06014command not implemented yet: string
ORA-19812cannot use string without DB_RECOVERY_FILE_DEST
ORA-24354number fetched too large to fit in COBOL display type buffer.
PGU-00359monitor already active
ORA-31679Table data object string has long columns, and longs can not be loaded/unloaded using a network link
QSM-00768the search condition is invalid for the requested operation
ORA-12511TNS:service handler found but it is not accepting connections
NNL-01061Cache checkpoint interval: string
CLST-02201node string already exists in the configuration with node number string
ORA-16060Log file is current
ORA-31485invalid database link
ORA-02189ON <tablespace> required
ORA-39050parameter string is incompatible with parameter string
NZE-28873Invalid parameter
NNL-00952Cache lookup failures: number
ORA-16268user procedure processing of logical standby apply PL/SQL




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