2
Loading Stored Procedures

Before you can call Java stored procedures, you must load them into the Oracle RDBMS and publish them to SQL. Loading and publishing are separate tasks. Many Java classes, referenced only by other Java classes, are never published to SQL.

To load Java stored procedures automatically, you use the command-line utility loadjava. It uploads Java source, class, and resource files into a system-generated database table, then uses the SQL CREATE JAVA {SOURCE | CLASS | RESOURCE} statement to load the Java files into the RDBMS. You can upload Java files from OS file systems, popular Java IDEs, intranets, or the Internet.

Note: To load Java stored procedures manually, you use CREATE JAVA statements. For example, in SQL*Plus, you can use the CREATE JAVA CLASS statement to load Java class files from local BFILEs and LOB columns into the RDBMS. For more information, see the Oracle8i SQL Reference.

Major Topics

• Java in the Database

• Managing Java Schema Objects

• Using loadjava

• Using dropjava

• Invoker Rights versus Definer Rights

---