- An IN or INOUT argument must be a question mark (? is used as an input placeholder) or value expression, with the following conditions:
|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 the Teradata 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, refer to SQL Stored Procedures and Embedded SQL (B035-1148).