Java Stored Procedures for Oracle

Course Number:  546-JK
Recommended Duration:  2 days

Intended Audience
Experienced Java JDBC and Oracle developers who need to learn how create and use Oracle Java Stored Procedures.

Course Overview
Oracle database users with Java experience learn how to create, load, publish Java Stored Procedures with the Oracle database.  There are six machine exercises.

Course appropriate for Oracle 10g Java 2.0 (Java 1.4). Course covers Java 2.0 (aka. Java 1.4), however, most topics and examples also apply to Java 1.1, Java 1.2, Java 1.3, and Oracle8i or Oracle9i.

Objectives
Participants will enhance existing Java, Oracle, and PL/SQL skills by learning to develop, test, and deploy Java Stored Procedures.  Hands-on exercises reinforce new concepts.

Prerequisites
Students must have Java JDBC experience or have completed one of the "Java Essentials" courses (or equivalent) and "Using JDBC" (or equivalent). SQL and PL/SQL experience are also required.

Topics

• JVM and components

• Developing Java Stored Procedures

• Loading Java Stored Procedures

• Publishing Java Stored Procedures

• Using Java Stored Procedures from PL/SQL, SQL DML statements and triggers