SQL_GET_FUNCTION_RETURN¶
Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex
This variable is used to get the value returned from a SQL function call. After the function has been successfully called, this command takes the returned value and inserts it the given variable.
Syntax
SQL_GET_FUNCTION_RETURN to {variable}
Parameter |
Description |
|---|---|
variable |
Variable to hold the returned value |
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
SQL_SET_FUNCTION_PARAMETER