Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

CALL

Executes the specified stored procedure. Does not return results.

Syntax

CALL { procedure_name( [argument_list] )
       | database_name.procedure_name( [argument_list] ) };

Arguments

procedure_name

The name of the stored procedure to execute.

argument_list

A list of optional arguments to pass as input parameters to the stored procedure.

Example

The following example executes a stored procedure that accepts a VARCHAR as an input parameters.

CALL snapshot_db('db1');
Query OK, 0 rows affected (0.35 sec)

Related Topics The ECHO command is similar to CALL but it outputs a set of rows as a result.