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-31209: DBMS_LDAP: PL/SQL - LDAP count_entry error.

1 Answers  


EXP-00050: Cannot perform Partition Export "string" on non-partitioned table "string"

1 Answers  


ORA-24093: AQ agent string not granted privileges of database user string

1 Answers  


ORA-12820: invalid value for DEGREE

1 Answers  


ORA-16123: transaction string string string is waiting for commit approval

1 Answers  






ORA-07685: sou2os: supervisor stack set error

1 Answers  


PCC-02302: cannot open code generation output file "string"

1 Answers  


ORA-04022: nowait requested, but had to wait to lock dictionary object

2 Answers   Oracle,


ORA-37101: (XSVPART01) Partitioning information can only be given for variables dimensioned by a PARTITION TEMPLATE.

1 Answers  


PLS-00226: package 'string' used as variable reference

1 Answers  


ORA-09825: Unable to disable allowmacaccess privilege.

1 Answers  


ORA-12230: TNS:Severe Network error occurred in making this connection

1 Answers  


Categories