File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Publishing to another database

 
Shruti Sharma
Ranch Hand
Posts: 55
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 118
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic