The following rules apply to the input and output arguments submitted with the SQL CALL statement in ODBC:
- An IN or INOUT argument must be a question mark (? is used as an input placeholder) or value expression, with the following conditions:
Argument Condition A value expression Must not contain colon-preceded identifiers. It must be a constant expression. The value of the expression is treated as the input value for the corresponding parameter in the called stored procedure.
A NULL value expression can be used to initialize the corresponding parameter to NULL.
? The value for the corresponding IN or INOUT parameter of the called procedure must be set using ODBC-specific calls prior to calling the stored procedure. - An OUT argument must be an OUT call placeholder or a “?” character. A placeholder can consist of a Teradata data definition and database-supported FORMAT, TITLE, and NAMED phrases. If the argument is a “?” character, the value for the corresponding OUT parameter of the called procedure must be set using ODBC-specific calls prior to calling the stored procedure.
For the other rules and details governing the CALL statement and usage of stored procedure parameters, see Teradata Vantage™ - SQL Stored Procedures and Embedded SQL, B035-1148.