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

Syntax

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

Description

EXECUTE .

Parameters

ParameterDescription
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.

Examples

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);