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-07740slemop: incorrect handle size (programming error)
ORA-12838cannot read/modify an object after modifying it in parallel
ORA-13028Invalid Gtype in the SDO_GEOMETRY object
ORA-24153rule set string.string already exists
ORA-09846soacon: ARCH unable to open named pipe.
ORA-24313user already authenticated
PLS-00329schema-level type has illegal reference to string
PLS-00394wrong number of values in the INTO list of a FETCH statement
ORA-07241slemrd: read error.
DIA-48929The trace record size exceeded the max size that can be read [string]
ORA-19295XQST0060: It is a static error if the name of a function in a function declaration is not in a namespace (expanded QName has a null namespace URI)
ORA-47180Integration Policy for OLS Policy string is already defined
ORA-29834REF datatype not supported with operators
RMAN-06206Crosschecked string objects
ORA-01281SCN range specified is invalid
ORA-36162(XSMXAGGR05) COUNTVAR variable workspace object must be of type INTEGER, not string.
ORA-06007NETASY: bad dialogue format
TNS-04011Oracle Connection Manager instance not yet started.
PLS-00126selector ALL is not allowed
NNL-00529set|show default_domain [<domain_name>] : set|show the current default domain




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
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
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