This topic describes the CALL statement and how to execute this statement.
Syntax
CALL procedure_name '('[argument_list]')'Description
You can execute the CALL statement to call a stored procedure. To execute 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. Take note of the following item: Each member in the list corresponds to a formal parameter that is required by the stored procedure. Each formal parameter can be an IN, OUT, or INOUT parameter. |
Examples
One of different types of syntax can be used for the CALL statement. The used syntax varies based on the parameters that are required by the stored procedure:
CALL update_balance();
CALL update_balance(1,2,3);