Skip to main content

CALL

Calls a procedure.


Syntax

CALL <name> ( [ <argument> ] [, ...] )

Description

To run CALL, you must have the EXECUTE privilege on the procedure to be invoked.

If the procedure has any output parameters, then a result row will be returned, containing the values of those parameters.


Parameters

  • <name>

    The name of the procedure. You can specify the name with the schema qualification.

  • <argument>

    The input argument for the procedure call.


Usage notes

To call a function (not a procedure), use SELECT instead.

If CALL is invoked in a transaction block, then the called procedure cannot run transaction control statements. Transaction control statements are only allowed if CALL is invoked in its own transaction.


Examples

Call procedure product_count():

CALL product_count();

SQL standard compatibility

CALL conforms to the SQL standard.