SQL_FUNCTION_EXECUTE¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command is used to execute the function statement that was built by the SQL_SET_FUNCTION_NAME and subsequent SQL_SET_FUNCTION_PARAMETER commands. This works similarly to the SQL_EXECUTE_STMT command. Note that executing the function with this command will not get any returned values but will simply execute the function.

Syntax

SQL_FUNCTION_EXECUTE

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

Related commands