permaculture playing cards*
The moose likes JDBC and the fly likes Question about stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Question about stored procedure" Watch "Question about stored procedure" New topic

Question about stored procedure

Cathy Young
Ranch Hand

Joined: Mar 02, 2002
Posts: 126
I am writing a Java Stored Procedure on Oracle 8i. This java class needs several .jar files to compile and run. How can I tell the Oracle server about these jar files?
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Load them into the database using Oracle's loadjava utility.
See the Oracle documentation for more details. You may also like to try Ask Tom, MetaLink or Oracle Technology Network.
Perhaps even do an Internet search or search the archives of the "*" newsgroups for "loadjava".
Good Luck,
Cathy Young
Ranch Hand

Joined: Mar 02, 2002
Posts: 126
Thanks a lot for your help, Avi!
I agree. Here's the link:
subject: Question about stored procedure
Similar Threads
writing log to a file from java stored procedure
Stored java procedure error on oracle client
Weblogic Connection Pool, Oracle Stored Procedure, Remote Sybase Database
Using JDBC for a remote call in Oracle
Problem using Callable Statement