Oracle - JBDC CallableStatement

JDBC for Oracle - Herong's Tutorial Examples

∟Oracle - JBDC CallableStatement

This chapter provides tutorial notes on JDBC CallableStatement objects for stored procedures. Topics include CallableStatement overview; creating stored procedures with parameters; using place holders in CallableStatement objects; register output parameters.

Overview of CallableStatement Objects

"CREATE PROCEDURE" - Creating a Simple Procedure

Creating Procedures with IN and OUT Parameters

Creating CallableStatement Objects with prepareCall()

Creating CallableStatement Objects with Parameters

getProcedures() - Listing Stored Procedures

Takeaways:

A JDBC CallableStatement object allows you to call stored procedures in the database server.
IN and OUT parameters can be passed to stored procedures from JDBC CallableStatement objects.

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Oracle Express Edition Installation on Windows

Oracle JDBC Drivers

Oracle - Reference Implementation of JdbcRowSet

Oracle - PreparedStatement

►Oracle - JBDC CallableStatement

Oracle CLOB (Character Large Object) - TEXT

Oracle BLOB (Binary Large Object) - BLOB

Archived Tutorials

References

Full Version in PDF/EPUB