# CALL¶

Calls a stored procedure.

## Syntax¶

CALL <procedure_name> ( [ <arg> , ... ] )


## Usage Notes¶

• Procedure names are not necessarily unique within the schema; stored procedures are identified and resolved by their arguments types as well as their names (i.e. stored procedures can be overloaded).

• The value returned by the stored procedure cannot be used, because the call cannot be part of an expression.

• Stored procedures are not atomic; if one statement in a stored procedure fails, the other statements in the stored procedure are not necessarily rolled back. For information about stored procedures and transactions, see Transaction Management.

## Examples¶

CALL sv_proc1('Manitoba', 127.4);

SET Variable1 = 49;
CALL sv_proc2(\$Variable1);


For more extensive examples of creating and calling stored procedures, see Working with Stored Procedures.