16.10 - Output From Stored Procedures - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Programming Reference
Publication ID
B035-1141-161K
Language
English (United States)

Stored procedures can return output values in the INOUT or OUT arguments of the CALL statement. They can also return result sets, the results of SELECT statements that are executed when the stored procedure opens result set cursors. To return result sets, the CREATE PROCEDURE or REPLACE PROCEDURE statement for the stored procedure must specify the DYNAMIC RESULT SET clause.

Related Topics

For details on how to write a stored procedure that returns result sets, see SQL Stored Procedures and Embedded SQL , B035-1148 .