17.05 - Retrieving Values of Output Parameters - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

The output values of INOUT and OUT parameters are returned after completion of the CALL statement in the following forms:

CALL is Issued from this Type of Application Output Parameter Values
BTEQ Result row.
CLIv2

The values for all the INOUT and OUT parameters are returned in one row, irrespective of the number of parameters.

The value of each parameter is a field in the output.

Embedded SQL Stored in the corresponding host variable.
Another procedure stored in the corresponding local variable or parameter of the calling procedure.
ODBC To be retrieved using an ODBC API.
JDBC To be retrieved using a JDBC API.