3
Publishing Stored Procedures

Before calling Java methods from SQL, you must publish them in the Oracle data dictionary. When you load a Java class into the RDBMS, its methods are not published automatically because Oracle does not know which methods are safe entrypoints for calls from SQL. To publish the methods, you must write call specifications (call specs), which map Java method names, parameter types, and return types to their SQL counterparts.

Major Topics

• Understanding Call Specs

• Defining Call Specs: Basic Requirements

• Writing Top-Level Call Specs

• Writing Packaged Call Specs

• Writing Object Type Call Specs

---