How to include jar files to a Java Stored Procedure in Oracle?

java oracle stored-procedures java-stored-procedures
Florian Müller picture Florian Müller · Feb 7, 2012 · Viewed 14.8k times · Source

I'm realizing a stored procedure and need now the ability to include jar files to my stored procedure, which do not belong to the standard deployment of the JRE. How can I do this? As I know wasn't it possible with Oracle 9 ...

Thanks for help!

Answer

Martin Klinke picture Martin Klinke · Feb 7, 2012

Use the loadjava tool, it accepts jar files, too: http://docs.oracle.com/cd/B19306_01/java.102/b14187/cheleven.htm#CACFHDJE

See also this related question (copied the above link from there): Setting classpath for a Java stored procedure in Oracle

Related questions

Spring's Stored Procedure - results coming back from procedure always empty

I am using Spring's JdbcTemplate and StoredProcedure classes. I am having trouble getting the stored procedure class to work for me. I have a stored procedure on an oracle database. Its signature is CREATE OR REPLACE PROCEDURE PRC_GET_USERS_…

Read More
How to read a ARRAY of types returned from a stored proc using java?

This is a continuation of the question posted under the following location: Java program to pass List of Bean to a oracle stored procedure - Pass entire list at one shot rather than appending objects one after the other I …

Read More
Java: Returning XMLType Data from StoredProcedure, Usage of ojdbc6.jar xdb6.jar xmlparserv2.jar for Java to PLSQL interaction

I am following the below tutorial to retrieve XMLType data from a stored procedure http://docs.oracle.com/cd/B19306_01/appdev.102/b14259/xdb11jav.htm#g1039140 Example 13-4 XMLType Java: Returning XMLType Data When I run the code, I get …

Read More