SQL_SET_FUNCTION_PARAMETER¶
Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex
The SQL_SET_FUNCTION_PARAMETER command enables you to add a parameter to a stored function which you are planning to call. You can pass multiple parameters by calling the command for each parameter.
When passing parameters you’ll have to inform the driver which variable you are passing, starting with 1 from left-to-right in the parameter list.
For each parameter you’ll have to indicate if the variable is to be regarded as input, output or both.
Syntax
SQL_SET_FUNCTION_PARAMETER {number} to {variable} {direction}
Parameter |
Description |
|---|---|
number |
Index number of the parameter being defined. |
variable |
Variable holding the parameter to be passed. |
direction |
IN, OUT, IN_OUT, RSET, or leave blank |
Example
SQL_SET_FUNCTION_NAME "getCustomerStatus" NUMPAR 1
SQL_SET_FUNCTION_PARAMETER 1 to 'Jones' IN
SQL_FUNCTION_EXECUTE
SQL_GET_FUNCTION_RETURN to dDOB
Showln dDOB