Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Oracle/OAS and the fly likes Publishing to another database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Publishing to another database" Watch "Publishing to another database" New topic
Author

Publishing to another database

Shruti Sharma
Ranch Hand

Joined: Mar 25, 2010
Posts: 55
Hi,

I create some data in my system (one application). I need to publish that data in the Oracle database of another system (another application) by calling their stored procedure. How can I do that?
One way is to send data to this second system and they can populate it on their own. Is there any other way? Is there a way to directly connect to the second system and invoke their stored procedure to insert data into their database?

Thank you,
-Shruti
Agador Paloi
Ranch Hand

Joined: Jan 24, 2006
Posts: 118
There is a couple of ways you can do this.
- you can use a trigger in system A table to update a table in system B
- System B can grant permissions to system A to execute a stored procedure that does the update in system B,
assuming the system run in different schemas.

In either case , permissions will need to be granted for the update of system B.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Publishing to another database