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.