Originally posted by Shadis
Hi,


I need to create a trigger that copy (insert update delete) certain record from oracle table to sql server table.

how can i do such a thing?

Thanks
You could write a java package, place it in the Oracle database, and have that java package take some data and insert it into a sql server database using the jdbc driver for SQL Server. Then all you would have to do is call the Java package from your trigger and pass the right information.

You could probably do the same thing with an external c program.