Java Stored Procedures Developer's Guide
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
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
JAVA statements. For example, in SQL*Plus, you can use the
CLASS statement to load Java class files from local
LOB columns into the RDBMS. For more information, see the Oracle8i SQL Reference.