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-31495: error in synchronous change table on "string"."string"

ORA-32825: Messaging Gateway agent has not been started

ORA-27211: Failed to load Media Management Library

ORA-01085: preceding errors in deferred rpc to "string.string.string"

ORA-01924: role 'string' not granted or does not exist

SQL*Loader-00640: Variable length field was truncated.

ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

ORA-01214: MAXLOGHISTORY may not exceed string

ORA-08006: specified row no longer exists

ORA-22628: OCIAnyData already constructed

NID-00301: Datafile string - dbid changed, wrote new name

ORA-12059: prebuilt table "string"."string" does not exist

For more Oracle Errors Interview Questions Click Here