Re: Way to create a Procedure to talk to SQL Server?

From: srinivasarao panganamamula <spanganamamula_at_cinci.rr.com>
Date: Wed, 15 Jan 2003 18:56:22 GMT
Message-ID: <q9iV9.5283$i73.1037067@twister.neo.rr.com>

Oracle offers two connectivity solutions for the heterogeneous environment. Generic Connectivity and Oracle Transparent Gateways. Both Generic Connectivity and Oracle Transparent Gateways provide the ability to transparently access data in non-Oracle systems

from an Oracle environment.

Check http://otn.oracle.com for more information. Transparent gateways may be a licenses product.

"John Deackman" <jdeack_at_mhtc.net> wrote in message news:6XgV9.137338$Hs2.12245628_at_kent.svc.tds.net...
> I have a colleague who is looking to write a procedure (PL/SQL) in the
> oracle database to connect to a SQL Server database to either drop or pull
> data. Has anyone done this and if so would they have sample code I could
> look at to see how this is done? I am new to Oracle and so is my
colleague.
> We aren't sure if we need third party software to do this, but prefer not
> to.
>
> Thank You!
> John Deackman
>
Received on Wed Jan 15 2003 - 12:56:22 CST