Teradata Database Message 7627 - 7627 - Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
Teradata® Vantage™
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.