DB LINK b/w Oracle and SQL Server?

[Dan Stillwater]

Hi,

I want to select some data from on the of the databases and to insert it
into the other and vice-versa
(not a one-time deal), in a single SQL Statement.

Is it possible to create a DB link between SQL Server 7 and Oracle 7.3.3
(both ways), so I could use a
single SQL Insert statement?

Please remove the NOSPAM from my e-mail id, before replying.

Thanks for your help,
Dan.

[Kevin]

"Dan Stillwater" <newuser69@hotmail.nospam.com> wrote:
...
>Is it possible to create a DB link between SQL Server 7 and Oracle 7.3.3
>(both ways), so I could use a
>single SQL Insert statement?
.....

Dan,
The "within a single SQL statement" is where things get expensive. Oracle
sells a product called Oracle Transparent Gateway for MS SQL Server which
handles the abstraction of inter-database communication to allow you to perform
what you want in a single transaction.

It costs $10,000.

On the good side, that is the retail price ;-).