SQL Server connection from Oracle Proc'

SQL Server connection from Oracle Proc'

 

  

Hi all

I have a requirement to connect to a SQL server database from within an Oracle procedure.

After reviewing the Oracle docs, it seems there are gateway products, which may/may not require additional software e.g. agents.

Has anyone achieved this? Any further ideas/thoughts?

Many thanks Martin



--

------------------------------------------------------------------------------
HBOS plc, Registered in Scotland No. SC218813. Registered Office: The Mound, Edinburgh EH1 1YZ. HBOS plc is a holding company, subsidiaries of which are regulated by the Financial Services Authority.
==============================================================================

Oracle LazyDBA home page