
September 30th, 2004, 11:02 AM
|
|
Contributing User
|
|
Join Date: Aug 2003
Posts: 58
Time spent in forums: 50 m 23 sec
Reputation Power: 6
|
|
|
Creating Java Stored Procedures
Good Day, I'm trying to create a java stored procedure.
Created java class using public static methods to convert them to Java Stored Procedures.
Java Stored Procedures have dependencies to an IBM AS400 jdbc driver and Oracle jdbc thin driver.
I'm using oracle loadjava utility to register local classes into oracle database.
I got some questions:
If Java Stored Procedure uses IBM AS400 jdbc driver (j400.jar file), what steps must follow to integrate AS400 driver into oracle database or as external depencency?.
Oracle thin driver is included on oracle schema?
What privileges must be granted to execute Java Stored Procedures using jdbc to another databases?
I appreciate some help.
Best Regards
|