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

SQL*Loader-00463: secondary data file for LOB is string

ORA-06772: TLI Driver: error sending command

ORA-22888: duplicate SCOPE clauses for a REF column

ORA-39051: parameter string specified multiple times

NZE-29048: Unexpected message received.

SQL*Loader-00932: Could not truncate table string.

NNL-00810: Queries received with no type: number

ORA-37107: (XSVPART07) Attempt to write to non-existent partition of workspace object.

ORA-31108: Action failed as resource string is locked

ORA-01295: DB_ID mismatch between dictionary string and logfiles

ORA-09740: slsget: cannot get virtual memory region statistics.

QSM-01033: query rewritten with materialized view, string

For more Oracle Errors Interview Questions Click Here