Getting Ora-28502 When Query Located In Stored Procedure Ora-28502 Using HSODBC 10.2

(Doc ID 395080.1)

Last updated on JULY 28, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
***Checked for relevance on 28-Jul-2011***

Symptoms

Using 10.1
A stored procedure issuing a select statement to SQL Server using Generic Connectivity 10.1  works without any problems.
A synonym is created for the SQL Server select and works if a remote stored procedure selects
against the synonym.

Using 10.2
The same stored procedure works when selecting data from a SQL Server database using Generic Connectivity 10.2.
A synonym is created for the SQL Server select but fails with this error when accessed via a
remote stored procedure -

Error 28500 trapped in 2PC on transaction 13.45.159892. Cleaning up.
Error stack returned to user:
ORA-02050: transaction 13.45.159892 rolled back, some remote DBs may be in-doubt
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][S1000] [9013]General error in nvITrans_Commit - rc = -1. Please
refer to the log file for details.
ORA-02063: preceding 2 lines from ICDEV2
ORA-02063: preceding 3 lines from ICPASSTHRU

If the same synonym is accessed from SQLPLUS then it works.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms