SQL-02112: SELECT..INTO returns too many rows

Question Posted / guest

SQL-02112: SELECT..INTO returns too many rows..

Answer / guest

Cause: A SELECT...INTO statement returned more rows than can
be stored in the host variable provided.

Is This Answer Correct ?

14 Yes

4 No

More Oracle Errors Interview Questions

NID-00109: DBNAME string length number exceeds maximum length of number

TNS-01177: Log Status is OFF. Log file/directory unchanged

ORA-24420: OCISessionRelease must be used to release this session.

ORA-04930: open sequence number failed or initial state is valid

ORA-00347: log string of thread string, expected block size string doesn't match string

ORA-30183: invalid field width specifier

ORA-36266: (XSCGMDLAGG00) Invalid context for the AGGREGATION function

ORA-19006: XMLType TYPE storage option not appropriate for storage type

ORA-15043: ASM disk "string" is not a diskgroup member

ORA-12685: Native service required remotely but disabled locally

ORA-00200: controlfile could not be created

ORA-36276: (XSCGMDLAGG06) Current operator does not need the weight variable.

For more Oracle Errors Interview Questions Click Here