Setting classpath for a Java stored procedure in Oracle

Question

I've got an Oracle 10g database, and I have a third-party jar file. I want to be able to run a SQL select query in my database that ultimately runs code in my third-party library to retrieve info for inclusion in a SQL result set. I see lots of tutorials on "Java stored procedures" and these seem to be a promising way to do this, but none seem to use third-party libraries, and I can't seem to figure out how to specify a classpath for my jar file that will be recognized when I am running in Oracle. How can I do this?

Irfan · Accepted Answer · 2011-12-29 17:48:59Z

11

You can load the JAR file into the database using the loadjava tool. This tool accepts also .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.

edited Dec 29, 2011 at 17:48

Irfan

6071 gold badge6 silver badges12 bronze badges

answered Feb 9, 2009 at 19:55

Edwin

2,6812 gold badges19 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Joshua · Accepted Answer · 2009-02-09 19:24:07Z

0

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

answered Feb 9, 2009 at 19:24

Joshua

26.8k22 gold badges80 silver badges107 bronze badges

1 Comment

Chris Farmer Over a year ago

Is there a way I can do this without altering the machine environment?

Collectives™ on Stack Overflow

Setting classpath for a Java stored procedure in Oracle

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related