Chapter 26. Using Java with PL/SQL

One of Oracle8i’s major new features is the ability to store and execute Java programs inside the database, giving Oracle developers another server-side development language (the first language, of course, is PL/SQL). These Java stored procedures (JSPs) open up a whole new realm of potential applications. For example, developers can use the Java networking classes to allow their database applications to communicate directly with network applications, such as a web server, on other computers.

Fortunately for us, Oracle has made PL/SQL and Java interoperable, allowing PL/SQL developers to call JSPs and Java developers to call PL/SQL stored procedures. This chapter tests your ability to define PL/SQL wrappers that allow you to call JSPs within PL/SQL.



Oracle8i’s Java Virtual Machine is called:

  1. SunSpot

  2. Nova

  3. Aurora

  4. Prometheus

  5. Zeus


True or false?

  1. Java performance stinks because you have to download an applet across the network.

  2. You must know Java to take advantage of it in Oracle8i.

  3. You can call Java-stored procedures from a variety of clients, including SQL, PL/SQL, Java applets, Pro*C, Visual Basic, and Oracle Forms.

  4. Except for its ugly syntax, Java is just like PL/SQL.

  5. Java has hundreds of built-in classes to use in your PL/SQL programs.

  6. Java is a replacement for PL/SQL.

  7. Java, like PL/SQL, is a proprietary language controlled by Oracle.

  8. You can run your Java programs on a variety of platforms with very little effort.

  9. Java programs, such as C or C++ ...

Get Oracle PL/SQL Programming: A Developer's Workbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.