C H A P T E R 6
CallableStatement interface extends
PreparedStatement to execute and retrieve data from stored SQL procedures. In this chapter, you'll explore in detail how to invoke stored SQL procedures from JDBC using the SQL92 syntax and Oracle syntax. Toward the end of the chapter, I'll make a strong case for almost always wrapping code in stored SQL procedures, and invoking the stored procedures using
CallableStatement as opposed to embedding them in a JDBC program and using
PreparedStatement to execute them.
A Brief Introduction to Stored Procedures and PL/SQL
Stored procedures allow you to perform certain tasks procedurally ...