I’ll try to demonstrate how we can use loadjava to load our Java class into Oracle Database and use its methods as stored procedures. Before we begin to write the Java codes, I’ll create a simple table. When I call my java stored procedure, it will insert a record to this table.

I created this table in HR schema because I’ll load my java object in HR schema. If you’ll use another schema, then do not forget to load your java code in same schema or set required permissions. This is the main method I’ll use as my stored procedure:

As you see, we can use “default connection” to connect the database we’ll load our Java. I use “PreparedStatemen” to add the bind variables to SQL statement and run it. I need to handle exceptions, so I add try/catch block and add the required “import” directives, so this is the final version:

Save this file as “JavaSample” and then issue the following command:

Let’s check if it’s loaded:

Now we will create an interface procedure for our Java procedure in PL/SQL:

Let’s call our procedure and check if a new record will be inserted to our table: