O'Reilly logo

Expert Oracle PL/SQL by Michael McLaughlin, Ron Hardman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required