Oracle provides the LoadJava tool to create schema objects from Java source, class, data files or SQLJ files. The LoadJava tool is located in the bin directory under $ORACLE_HOME.
CREATE PROCEDURE and CREATE TABLE privileges are required to load into your schema.
CREATE ANY PROCEDURE and CREATE ANY TABLE privileges are required to load into another schema using the -schema option.
LoadJava can be executed either from the command line or by using the loadjava method contained in the DBMS_JAVA class which allows you to execute from within your Java application.
Command Line Example
loadjava -force -genmissing -r -user scott@orcl-verbose core-1.7.jar
Calling from a Java application
call dbms_java.loadjava(‘… options…’);
The options are the same as those that can be specified on the command line with the loadjava tool. Separate each option with a space. Do not separate the options with a comma. The only exception for this is the -resolver option, which contains spaces. For -resolver, specify all other options in the first input parameter and the -resolver options in the second parameter, as follows:
call dbms_java.loadjava(‘..options…’, ‘resolver_options’);
Do not specify the -thin, -oci, -user, and -password options, because they relate to the database connection for the loadjava command-line tool. The output is directed to stderr. Set serveroutput on, and call dbms_java.set_output, as appropriate.