CALL v13
Name
CALL
Synopsis
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: