Query Using DG4MSQL Returns Error After Upgrade of RDBMS From 10.2.0.3 to 10.2.0.4 (Doc ID 1078940.1)

Last updated on SEPTEMBER 30, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Oracle Database Gateway for SQL Server - Version: 11.1.0.6 to 11.1.0.7   [Release: 11.1 to 11.1]
Generic Windows

Symptoms

After upgrade of the Oracle database from 10.2.0.3 to 10.2.0.4 patch 22, a query that was running on database 10.2.0.3 using Database Gateway for SQL*Server 11.1 started failing with error -


ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for MSSQL][A096] Unknown function TO_DATE() with 2 operands ORA-02063: preceding 2 lines from GTW_LINK
ORA-01002 : fetch out of sequence


Changes

Upgrade of the RDBMS being used to connect to the gateway from 10.2.0.3 to 10.2.0.4 patch 22.

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