This topic describes the CALL statement and how to execute this statement.
CALL procedure_name '('[argument_list]')'
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.
|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.|
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);