Steps Required to Create a Java Stored Procedure

To develop a Java stored procedure, follow these steps:

  1. Write the stored procedure

  2. Load the procedure in the Oracle database

  3. Publish the procedure in the Oracle data dictionary

  4. Call the procedure

Write the Stored Procedures

Any Java IDE such as Oracle's JDeveloper and Symantec's Visual Café can be used to write your stored procedure.

Load the Procedure in the Oracle Database

In order for the Java files to be available to the Aurora JVM, they must be loaded into the Oracle database as schema objects. Each Java class is stored as a schema object and the object name is derived from the fully qualified name of the class (including the package name).

Note

Oracle accepts Java names of up to 4,000 characters ...

Get e-Commerce Applications Using Oracle8i and Java from Scratch now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial