External stored procedures support two types of parameter passing conventions.
Parameter Passing Convention | Description |
---|---|
Parameter Style SQL | Provides a way to pass nulls as IN or INOUT arguments and return nulls as INOUT or OUT arguments. |
Parameter Style TD_GENERAL | Does not accept null IN or INOUT arguments and does not return null INOUT or OUT arguments. |
The parameter passing convention you use to code an external stored procedure must correspond to the parameter passing specification in the CREATE PROCEDURE statement for the external stored procedure.
IF CREATE PROCEDURE specifies … | THEN use the following syntax for the function parameter list … |
---|---|
PARAMETER STYLE SQL or omits the PARAMETER STYLE option | Syntax for Parameter Style SQL. |
PARAMETER STYLE TD_GENERAL | Syntax for Parameter Style TD_GENERAL. |