Forums Register Login

Using JDBC for a remote call in Oracle

+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
 

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
+Pie Number of slices to send: Send
That worked great.

Thanks!
I will suppress my every urge. But not this shameless plug:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1422 times.
Similar Threads
Problem using Callable Statement
Is it possible to have a store procedre that has PL/SQL code and can call a java obje
java stored procedure problems
getting the resultset of a stored procedure?
Calling stored procedures from Java
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 10:34:51.