Database Error Messages

SQL-02112

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 3 possible solutions:

  1. Use the precompiler option select_error=no.
  2. Declare a host variable with a larger array dimension.
  3. Declare a cursor or cursor variable for the select statement.