O'Reilly logo

Oracle Database 11g The Complete Reference by Kevin Loney

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 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, ...

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