Home » RDBMS Server » Networking and Gateways » Oracle 9i transparent gateway error
Oracle 9i transparent gateway error [message #28607] Thu, 08 January 2004 11:46
Aaron
Messages: 13
Registered: January 2002
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?

Report message to a moderator

Previous Topic: my oracle forms cant connect with database in th same system
Next Topic: Getting ORA-12545: Connect failed because target host or object does not exist
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 00:56:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.