Name

CALL

Synopsis

CALL <procedure_name> '('[<argument_list>]')'

Description

Use the CALL statement to invoke a procedure. To use the CALL statement, you must have EXECUTE privileges on the procedure that the CALL statement is invoking.

Parameters

procedure_name

procedure_name is the (optionally schema-qualified) procedure name.

argument_list

argument_list specifies a comma-separated list of arguments required by the procedure. Note that each member of argument_list corresponds to a formal argument expected by the procedure. Each formal argument may be an IN parameter, an OUT parameter, or an INOUT parameter.

Note: You must specify an OUT parameter in the CALL statement when calling a package function; the OUT parameter will act as an INOUT parameter during package overloading.

Examples

The CALL statement may take one of several forms, depending on the arguments required by the procedure:

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