wood burning stoves*
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
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 "comp.databases.oracle*" 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: http://aspose.com/file-tools
subject: Question about stored procedure
Similar Threads
Stored java procedure error on oracle client
Using JDBC for a remote call in Oracle
Problem using Callable Statement
Weblogic Connection Pool, Oracle Stored Procedure, Remote Sybase Database
writing log to a file from java stored procedure