Syntax

CALL procedure_name '('[argument_list]')'

Description

You can use the CALL statement to call a stored procedure. To use the CALL statement, you must have the EXECUTE privilege on the stored procedure that is called.

Parameters

Parameter Description
procedure_name The name of the stored procedure. The name can be schema-qualified.
argument_list A comma-separated list of parameters that are required by the stored procedure. Note that each member in the list corresponds to a parameter that is required by the stored procedure. Each parameter can be an IN, OUT, or INOUT parameter.

Examples

The CALL statement has different types of syntax based on the parameters that are required by the stored procedure:

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