My Oracle Support Banner

Database Gateway For Sql Server (Dg4MSQL) Using Triggers Gives Error Ora-02054 and Error Invalid object name (Doc ID 1307727.1)

Last updated on SEPTEMBER 02, 2018

Applies to:

Oracle Database Gateway for SQL Server - Version 11.1.0.6 to 11.2.0.1 [Release 11.1 to 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 11-Feb-2013**

Symptoms


An update on an Oracle table causes a trigger to fire which updates a SQL*Server 2008 table using Database Gateway for SQL*Server (DG4MSQL) but this gives the error -


ORA-02054: transaction 9.9.9999 in-doubt
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]Connection is busy with results for another
hstmt {HY000}
ORA-02063: preceding 2 lines from GATEWAY



The same trigger works successfully with 10g Transparent Gateway and SQL Server 2000.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.