CALL_STORED_FUNCTION¶

This command is deprecated

Applies to: ORAFlex MYSQLFlex PGFlex

This command is used to execute a function stored in the SQL backend. This is an alternative to building a function with the SQL_SET_FUNCTION_NAME, SQL_SET_FUNCTION_PARAMETER and SQL_FUNCTION_EXECUTE commands. This command builds and executes the function by setting the full function name, the parameter(s) to pass and the variable to hold the returned value. Note that this command can only return a single value so SQL_SET_FUNCTION_PARAMETER and SQL_SET_FUNCTION_NAME must be used when dealing with multiple return values.

Assumptions

Syntax

CALL_STORED_FUNCTION {function} Returns {variable} Passing {parameters}

Parameter	Description
function	Full name of the function
variable	Variable to hold the returned value
parameters	Parameter to pass to the function (can be multiple)

Example

Move 5 to sCustomerID
CALL_STORED_FUNCTION "getCustomerStatus" Returns sStatus Passing sCustomerID