C H A P T E R  6



ACallableStatement 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 ...

Get Expert Oracle JDBC Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.