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

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