Invoking a procedure using the CALL command If a procedure uses only IN parameters, can execute the procedure by using the SQL CALL command. A stored procedure with IN, OUT, or INOUT parameters can be invoked from a client application by using a CallableStatement. Database-side JDBC proceduresinvoking with CALL command

You can invoke the procedure in an SQL statement such as the following:

CALL MYPROC() You can roll back a CALL statement only if no commits or rollbacks occur within the specified procedure.

You can also use the CALL command to execute a routine that returns a value, but you will not be able to access the value.