Search code examples
javaoracle-databasestored-proceduresjava-stored-procedures

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


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!


Solution

  • 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