Geek Answers Handbook

Configuring the path class for a Java stored procedure in Oracle

I have an Oracle 10g database and I have a third-party jar file. I want to be able to run the SQL select query in my database, which ultimately runs the code in my third-party library to retrieve information for inclusion in the SQL result set. I see a lot of tutorials on "Java-stored procedures", and it seems like a promising way to do this, but no one seems to use third-party libraries, and I cannot figure out how to specify the path to my bank the file to be recognized. when I will work in Oracle. How can i do this?

+5
source share
2 answers

You can load the JAR file into the database using the loadjava tool. This tool also accepts .class, .java, .properties, .sqlj, .ser, .jar, or .zip files.

See the manual ( http://docs.oracle.com/cd/B19306_01/java.102/b14187/cheleven.htm#CACFHDJE for more information ).

+11
source

Try adding a jar to the Windows / Unix CLASSPATH system variable.

0
source

More articles:


All Articles