Re: How to link to SQL Server using Oracle without using Oracle Gateway

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Thu, 30 May 2002 03:07:45 GMT
Message-ID: <5IgJ8.50762$ux5.65722@rwcrnsc51.ops.asp.att.net>

Depends upon the version of Oracle. You could use Java and a Java driver to call a stored procedure from Oracle to SqlServer. You would load the java into the Oracle database.
Jim
"Brian Li" <brian_li_at_newyorklife.com.hk> wrote in message news:3df45b1d.0205291755.27be4b45_at_posting.google.com...
> Oracle Transparent Gateway is expensive bundle, how can I link a SQL
> Server in Oracle without using Oracle Transparent Gateway?
>
> Can I call SQL Server's Store Procedure in Oracle Store Procedure?
>
> If can, can you explain it detail?
>
> Thanks a lot!
Received on Wed May 29 2002 - 22:07:45 CDT