The error is because in 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.