This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
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
Similar Threads
stored procedure inside another stored procedure
Speed Up JDBC Process with Oracle and Sybase
java oracle simultaneous transaction problem
How to get data in xml format from oracle 9i thru stored procedure
How to retrieve data in xml format through stored procedure in oracle 9?