Invoking a procedure using the CALL command

If a procedure uses only IN parameters, Derby 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.

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

CALL MYPROC()

Note: 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.