ORA-01422: exact fetch returns more than requested number of rows

ORA-01422: exact fetch returns more than requested number of rows

Cause: The number specified in exact fetch is less than the rows returned.

Action: Rewrite the query or change number of rows requested

ORA-01422: "exact fetch returns more than requested number of rows":

This can be for one of the following three reasons:

   1. There's a bug in the code and the developer did not realise that you could get more than one row returned;
   2. The data has been hacked rather than using the API so that validation has been broken;
   3. The software is OK, what the user did was OK, but two parallel updates occurred at the same time and neither could see the uncommitted change that the other did - hence not validated correctly.

ORA-00060: deadlock detected while waiting for resource

ORA-00936:missing expression

ORA-02063 remote db error and how to fix it

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-04091: table is mutating trigger

ORA-00604: error occurred at recursive SQL level string

PLS-00222: no function with name exists

ORA-00600: internal error code arguments:

ORA-21000:error number argument to raise_application_error is out of range

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00001: unique constraint

ORA-00017: session requested to set trace event

ORA-00018: maximum number of sessions exceeded

ORA-00019: maximum number of session licenses exceeded

ORA-00020: maximum number of processes exceeded.

ORA-00021: session attached to some other process; cannot switch session

ORA-00022: invalid session ID; access denied

ORA-00023: session references process private memory; cannot detach session

ORA-00024: logins from more than one process not allowed in single-process mode

ORA-00025: failed to allocate string

ORA-00026: missing or invalid session ID

ORA-00027: cannot kill current session

ORA-00028: your session has been killed

ORA-00029: session is not a user session

ORA-00030: User session ID does not exist.

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-00055: maximum number of DML locks exceeded

ORA-00060: deadlock detected while waiting for resource

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00600: internal error code arguments

ORA-00604: error occurred at recursive SQL level string

ORA-00936:missing expression

ORA-00997: illegal use of LONG datatype

ORA-01000:maximum open cursors exceeded

ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces

ORA-01480: trailing null missing from STR bind value

ORA-01555: snapshot too old: rollback segment number string with name "string" too small

ORA-03237: Initial Extent of specified size cannot be allocated in tablespace

ORA-04030: out of process memory when trying to allocate string bytes

ORA-04031: unable to allocate string bytes of shared memory

ORA-04091: table is mutating trigger

ORA-12154: TNS:could not resolve the connect identifier specified - Oracle Error

ORA-21000:error number argument to raise_application_error is out of range

ORA-28009: connection to sys should be as sysdba or sysoper

PLS-00222: no function with name exists

ORA-01422: exact fetch returns more than requested number of rows

Share on Google Plus

About Mindsforest