CALL

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

Get Started

Required privileges

Synopsis

Parameters

Examples

Call a stored procedure

See also

​Required privileges

​Synopsis

​Parameters

​Examples

​Call a stored procedure

​See also

Required privileges

Synopsis

Parameters

Examples

Call a stored procedure

See also