my dog learned polymorphism
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
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Publishing to another database" Watch "Publishing to another database" New topic

Publishing to another database

Shruti Sharma
Ranch Hand

Joined: Mar 25, 2010
Posts: 55

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,
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.
I agree. Here's the link:
subject: Publishing to another database
It's not a secret anymore!