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

ORA-06517: PL/SQL: Probe error - string

NNL-00406: Canonical name: string

NCR-04015: NCRR: Invalid interface name

ORA-01516: nonexistent log file, datafile, or tempfile "string"

ORA-13910: Parameter string cannot be NULL.

ORA-16611: operation aborted at user request

ORA-19212: no key columns specified before call to DBMS_XMLSTORE.updateXML()

ORA-25204: invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP

RMAN-06576: platform 'string' (number) found in header of datafile string does not mmatch specified platform name 'string' (number)

ORA-24007: invalid value string, MAX_RETRIES should be non-negative integer

ORA-02091: transaction rolled back

NZE-29194: no CRL found in cache

For more Oracle Errors Interview Questions Click Here