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. |