Teradata Database Message 7627 - 17.10 - 7627 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
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.
Notes
None
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.