Using Java Stored Procedures

A Java stored procedure is a Java method that resides and runs in a database. Stored procedures can help improve the performance of database applications because they are efficient: they are stored in the RDBMS in executable form, and run in the RDBMS (rather than the client) memory space.

Use JDeveloper to write methods in Java for new stored procedures and deploy them to an Oracle database. When you deploy a Java class to Oracle, you can select the methods that you want to publish to PL/SQL for use as stored procedures. Methods can be deployed together in a package or separately.

These topics describe aspects of using Java stored procedures:

For more information, see the Oracle Database Java Stored Procedures Developer's Guide, available from the Oracle Database 10g Documentation Library on the Oracle Technology Network (OTN) at http://www.oracle.com/pls/db92/db92.homepage.