Home » RDBMS Server » Networking and Gateways » Oracle Transparent Gateway Errors
Oracle Transparent Gateway Errors [message #60091] Thu, 15 January 2004 04:00
Aaron Street
Messages: 1
Registered: January 2004
Junior Member
We are using the oracle 9i transparent gateway for sql server and receive ora-03113 error when we do simple insert from oracle to sql server with where clause.

ex. fail script

Insert into tableA@dblink - sql server table
select valuea from tableb(oracle)
where valuea = 'value'

- work script

Insert into tableA@dblink - sql server table
select valuea from tableb(oracle)

Anyone seen this occur?
Previous Topic: help with 8i installation: tnslsnr.exe
Next Topic: Please help me with protocol adaptor error
Goto Forum:
  


Current Time: Thu Nov 21 21:24:20 CST 2024