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.