Database Error Messages

OCI-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.