Re: Firing Triggers in O7 to Sybase10

From: Dave Dargo <ddargo_at_us.oracle.com>
Date: 1996/01/30
Message-ID: <4ekdnm$g3n_at_inet-nntp-gw-1.us.oracle.com>#1/1


james.lawrence_at_epamail.epa.gov (Lawrence James) writes:

>In article <4dk4s3$kra_at_newsbf02.news.aol.com> diamonds2_at_aol.com (Diamonds2) writes:
>>From: diamonds2_at_aol.com (Diamonds2)
>>Subject: Firing Triggers in O7 to Sybase10
>>Date: 17 Jan 1996 19:39:31 -0500
 

>>Hi,
>
>Look into pipes.
>
>>Is it possible to create a trigger on an Oracle (O7.1.6) object and have
>>it write
>>to a Sybase object on the same server. Do we need to purchase the Gateway
>>product? Right now we spool data from Oracle and bcp into Sybase nightly,
>

The Oracle Transparent Gateway for Sybase allows an Oracle trigger to read and write to Sybase data - including two phase commit between Oracle and Sybase.

Dave (ddargo_at_us.oracle.com) Received on Tue Jan 30 1996 - 00:00:00 CET

Original text of this message