On this page 
The CALL statement invokes a stored procedure.
Required privileges
To call a procedure, a user must have EXECUTE privilege on the procedure.
Synopsis
Parameters
| Parameter | Description |
|---|---|
proc_name |
The name of the procedure to call. |
param_values |
A comma-separated list of parameter values. |
Examples
Call a stored procedure
The following statement calls the delete_earliest_histories example procedure, specifying 5 rows to delete and a rides_left cursor name:
CALL delete_earliest_histories (5, 'rides_left');
NOTICE: Deleted ride 0a3d70a3-d70a-4d80-8000-000000000014 with timestamp 2019-01-02 03:04:05
NOTICE: Deleted ride 0b439581-0624-4d00-8000-000000000016 with timestamp 2019-01-02 03:04:05.001
NOTICE: Deleted ride 09ba5e35-3f7c-4d80-8000-000000000013 with timestamp 2019-01-02 03:04:05.002
NOTICE: Deleted ride 0fdf3b64-5a1c-4c00-8000-00000000001f with timestamp 2019-01-02 03:04:05.003
NOTICE: Deleted ride 049ba5e3-53f7-4ec0-8000-000000000009 with timestamp 2019-01-02 03:04:05.004
CALL
See also
Was this helpful?
