Oracle Database 11g The Complete Reference

CHAPTER 44Java Stored Procedures

You can write stored procedures, triggers, object type methods, and functions that call Java classes. In this chapter, you will see a sample set of Java procedures, along with the commands required to execute a procedure. To get the most from this chapter, you should already be familiar with Java structures (refer to Chapter 42) and the uses of Java classes and JDBC (Chapter 43). You should also be familiar with the basic syntax and usage of stored procedures (refer to Chapter 35).

To focus on the database access operations of the Java classes, the example in this chapter is brief. The following class, called BookshelfDML, contains methods to insert and delete records from the BOOKSHELF table. In this example, ...