A procedure is executed using the SQL statement CALL, see "CALL - Execute procedure". A procedure can also be called using a dynamic CALL statement.
When a procedure expects input parameters, the corresponding values (arguments) must be transferred to the procedure in the CALL statement.
Output values of procedures which are called outside a routine care stored in corresponding host variables or in the SQL descriptor area. Output values of procedures which are called in a higher-level routine are entered in output parameters or in local variables of the higher-ranking procedure.
In order to execute a procedure, the current authorization identifier requires the EXECUTE privilege for the procedure to be executed, but not the privileges which are required to execute the DML statements contained in the procedure. In addition, the SELECT privileges for the tables which are addressed in the routine’s call parameters by means of subqueries are required.