aspose file tools*
The moose likes JDBC and the fly likes Using JDBC for a remote call in Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Using JDBC for a remote call in Oracle" Watch "Using JDBC for a remote call in Oracle" New topic
Author

Using JDBC for a remote call in Oracle

Chris Staten
Ranch Hand

Joined: Sep 24, 2004
Posts: 101
Hey all, I�m about to try and figure something out with some code that I�m working on. However, before I get started I wanted to ask a question, just to make sure that I�m not on a wild goose chase.

Is it possible to use JDBC to make a remote call from inside a Java Stored Procedure in one Oracle database (on its own database server) to a procedure/function in another Oracle database on a completely different database server?

Right now I�m attempting to use a DB link to call a Java Stored Procedure on Database_B from a PL/SQL procedure on Database_A. This is causing an error. I want to try to make the PL/SQL procedure on Database_A call a Java Stored Procedure in the same schema on Database_A. Then that Java Stored Procedure will use JDBC to call a function on Database_B. That function will call a Java Stored Procedure in its schema.
Annie Smith
Ranch Hand

Joined: Mar 05, 2005
Posts: 172
Originally posted by Chris Staten:

Is it possible to use JDBC to make a remote call from inside a Java Stored Procedure in one Oracle database (on its own database server) to a procedure/function in another Oracle database on a completely different database server?


Yes. Check this - http://www-rohan.sdsu.edu/doc/oracle/server803/A54642_01/ch7a.htm#2494


Cheers!<br /><b>Annie</b>
Chris Staten
Ranch Hand

Joined: Sep 24, 2004
Posts: 101
That worked great.

Thanks!
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Using JDBC for a remote call in Oracle