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.