In article <6XgV9.137338$Hs2.12245628_at_kent.svc.tds.net>, "John says...
>
>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
>
see
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76960/hs_genco.htm#173
you can access odbc data sources "as is" using generic connectivity. you need
no extra software, just some configuration and a dblink.
--
Thomas Kyte (tkyte@oracle.com) http://asktom.oracle.com/
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/
Opinions are mine and do not necessarily reflect those of Oracle Corp
Received on Wed Jan 15 2003 - 12:03:51 CST
