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

PCC-02382: You must specify MODE=ANSI when using NLS_LOCAL=YES

PLS-00140: duplicate external LIBRARY specification in subprogram expression

ORA-27250: OS system call failure

LSX-00230: invalid integer "~S"

ORA-13704: Invalid value "string" specified for parameter "string".

ORA-39079: unable to enqueue message string

DRG-12011: Authentication failed - retry?

TNS-00251: Failure in nstest:

IMG-00583: output format does not support the specified compressionFormat

ORA-09770: pws_look_up: translation failure.

ORA-09700: sclin: maximum number of latches exceeded

DRG-10762: index owner does not have access to procedure string

For more Oracle Errors Interview Questions Click Here