Oracle Error Codes

PCC: SELECT..INTO returns too many rows

A SELECT…INTO statement returned more rows than can be stored in the host variable provided.

How to Solve :

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.