• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

Using JDBC for a remote call in Oracle

 
Ranch Hand
Posts: 101
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
 
Chris Staten
Ranch Hand
Posts: 101
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That worked great.

Thanks!
 
Honk if you love justice! And honk twice for tiny ads!
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic