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



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

Answer / guest

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

Action: Rewrite the query or change number of rows requested

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06604: LU6.2 Driver: Unable to allocate session with remote LU

1 Answers  


ORA-38759: Database must be mounted EXCLUSIVE and not open.

1 Answers  


TNS-00087: * version - ask the process name to display its version number

1 Answers  


DRG-50802: failed to bind input

1 Answers  


ORA-27501: IPC error creating a port

1 Answers  






ORA-27459: A program of type EXECUTABLE must have character-only arguments.

1 Answers  


DRG-11712: multiple Broader Terms for term string

1 Answers  


ORA-32035: unreferenced query name defined in WITH clause

1 Answers  


ORA-24085: operation failed, queue string is invalid

1 Answers  


ORA-14085: partitioned table cannot have column with LONG datatype

1 Answers  


ORA-02248: invalid option for ALTER SESSION

1 Answers  


TNS-01150: The address of the specified listener name is incorrect

1 Answers  


Categories