4
Calling Stored Procedures

After you load and publish a Java stored procedure, you can call it. This chapter demonstrates how to call Java stored procedures in various contexts. You learn how to call them from the top level and from database triggers, SQL DML statements, and PL/SQL blocks. You also learn how SQL exceptions are handled.

Major Topics

• Calling Java from the Top Level

• Calling Java from Database Triggers

• Calling Java from SQL DML

• Calling Java from PL/SQL

• Calling PL/SQL from Java

• How Exceptions Are Handled

---