Calls a stored procedure.
CALL <procedure_name> ( [ <arg> , ... ] )
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.