Java Stored Procedures for Oracle

Recommended Duration:
2 Days
Version
Oracle 12c, Java SE 8
(suitable for earlier versions)
Benefits
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.
Audience
Experienced Java JDBC and Oracle developers who need to learn how create and use Oracle Java Stored Procedures.
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.
Major 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
Exercises
There are six machine exercises.