Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> 'Update data' in a SQLserver DB from Oracle Triggers

'Update data' in a SQLserver DB from Oracle Triggers

From: Tim Allen <tim.allen_at_ramesys.com>
Date: Thu, 23 Aug 2001 03:34:44 -0700
Message-ID: <F001.00374C76.20010823034130@fatcity.com>

<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=Wingdings 
color=#000080 size=2>(<FONT face="Times New Roman" size=2>      
Phone: 01788 822133 <FONT face=Wingdings color=#008000 size=2>.       <FONT face=Arial
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, NN6 
7SL <FONT face=Wingdings color=#0000ff
size=2>*         <FONT face=Arial
size=2>E-mail  : [<A
target=_blank
href="mailto:tim.allen_at_ram">mailto:tim.allen_at_ram<FONT face="Times New Roman" color=#0000ff size=4>e<FONT face=Arial color=#0000ff size=2>sys.com]
[ The views and opinions expressed
in the email are the sender's own   ][ and do not necessarily represent the views and opinions of Ram<FONT face="Times New Roman" color=#000000 size=4>e<FONT face=Arial color=#000000 size=2>sys LTD ]
  Received on Thu Aug 23 2001 - 05:34:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US