Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 'Update data' in a SQLserver DB from Oracle Triggers
<FONT face=Arial
size=2>Hi,
<FONT face=Arial
size=2>
I was wandering if
anyone has any experience of updating and inserting records in a SQLserver
database from Oracle?
<FONT face=Arial
size=2>
Someone has
mentioned DB links to me but I'm not convinced.
<FONT face=Arial
size=2>
The reason being
that I have a back office system with oracle as the database and a third party
system with a SQLserver database. The SQL server database will be able to
trigger other actions for its application once records have been inserted /
updated.
<FONT face=Arial
size=2>
<FONT face=Arial
size=2>Cheers
<FONT face=Arial
size=2>Tim
Tim Allen<FONT
face=Arial color=#008080 size=2>DesignerRam<FONT face="Times New Roman" color=#008080 size=4>e<FONT face=Arial color=#008080 size=2>sys (Professional Services) Ltd<FONT face=Wingdingscolor=#000080 size=2>(<FONT face="Times New Roman" size=2>
size=2>Fax : 01788 822144 <FONT face=Wingdings color=#ff0000 size=2>+ <FONT face=Arial size=2>Address : Eldon Way, Motorway Ind. Estate, Crick, Northants, NN67SL <FONT face=Wingdings color=#0000ff
![]() |
![]() |