Tag Archives: ORA-02112

ORA-02112: PCC: SELECT..INTO returns too many rows

oracle

ORA-02112: PCC: SELECT..INTO returns too many rows
Cause: A SELECT…INTO statement returned more rows than can be stored in the host variable provided.
Action: There are three possible solutions:
 Use the precompiler option SELECT_ERROR=NO.
 Declare a host variable with a larger array dimension.
 Declare a cursor or cursor variable for the select statement.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/