You can invoke the procedure in an SQL statement such as the following:
CALL MYPROC()
You cannot roll back this statement, because commits occur within the
procedure itself. Procedures that use nested connections, on the other hand,
are not permitted to commit or roll back and can therefore be rolled back
after the calling statement.
You can also use the CALL command to execute a procedure that does return
a value, but you will not be able to access the value.