15.00 - 7627 SELECT-INTO returned more than one row. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

7627 SELECT-INTO returned more than one row.

Explanation:

The SELECT-INTO SQL statement in the stored procedure has returned more than one row as a response. The stored procedure cannot handle more than one row.

Generated By:

RTS Modules.

For Whom:

End User.

Remedy:

Rewrite the query in the stored procedure to ensure that it returns at most one row, recreate the stored procedure, and resubmit the request. In order to use the multiple rows in the stored procedure, use FOR SPL statement.