Home -> Usenet -> comp.databases.oracle -> Replication of data from Oracle to SQL Server and Sybase using a trigger/procedure or java program

Replication of data from Oracle to SQL Server and Sybase using a trigger/procedure or java program

From: jameso <jamesong74_at_hotmail.com>
Date: 10 Jan 2002 17:38:15 -0800
Message-ID: <155bbed8.0201101738.7209ed3_at_posting.google.com> 






Hi, 


I am inserting data into Oracle DB from a Java servlet. After which, I
want to automatically insert the same data to SQL Server and Sybase
simultaneously.



Is it possible to do the above mentioned, either by writing a
trigger/procedure or calling another java program (servlet) to perform
the insertion?



If I call a trigger/procedure, where/how do I define the ip address,
user id and password of the SQL Server and Sybase DB in order to
insert the same data as the Oracle DB?



If a call another java program, where do I write it and how do I call
it from Oracle?



Are there any good links that I can refer to with regards to the
above?



Please advise.



Thank you.
Received on Fri Jan 11 2002 - 02:38:15 CET












Original text of this message