Chapter 5. Extending PL/SQL with Java Libraries

Extending stored programs with Java is a very popular solution. PL/SQL is essential to the process of stored Java class libraries. PL/SQL wraps access to the Java class libraries, which means PL/SQL becomes the gate through which data moves to and from Java stored objects.

This chapter stands independent of others in the book since all its content works in currently supported versions of the Oracle database. We'll be covering the following topics:

  • Java architecture in Oracle

  • Oracle JDBC connection types

    • Client-side driver, or JDBC thin driver

    • Oracle call interface driver, or middle-tier thick driver

    • Oracle server-side internal driver, or server-tier thick driver

  • Building Java class libraries in Oracle

Get Expert Oracle PL/SQL 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.