On this page Carat arrow pointing down

The CALL statement invokes a stored procedure.

Required privileges

To call a procedure, a user must have EXECUTE privilege on the procedure.


CALL proc_name ( param_values )


Parameter Description
proc_name The name of the procedure to call.
param_values A comma-separated list of parameter values.


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

See also

Yes No
On this page

Yes No