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 Teradata Vantage™ - SQL Stored Procedures and Embedded SQL , B035-1148 .