DBA > Job Interview Questions > DERBY Java Database FAQs

How to invoke a Procedure Using the CALL Command

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How to invoke a Procedure Using the CALL Command

If a procedure does not return a value, Derby can execute the procedure using the SQL CALL command. You can invoke the procedure in an SQL statement such as the following:

CALL MYPROC()

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

(Continued on next question...)

Other Job Interview Questions