This topic describes the EXEC statement and how to use it.


EXEC function_name ['('[argument_list]')']




Parameter Description
procedure_name procedure_name is the function name. The name can be schema-qualified.
argument_list argument_list specifies a comma-separated list of arguments that are required by the function. Take note of the following item: Each member of argument_list corresponds to a formal parameter that is required by the function. Each formal parameter may be an IN, OUT, or INOUT parameter.


You can use multiple formats for the EXEC statement. The used format depends on the parameters that are required by the following functions:

EXEC update_balance;
EXEC update_balance();
EXEC update_balance(1,2,3);