CALL

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