Query Using DG4MSQL Returns Error After Upgrade of RDBMS From to

(Doc ID 1078940.1)

Last updated on SEPTEMBER 30, 2010

Applies to:

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


After upgrade of the Oracle database from to patch 22, a query that was running on database 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


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


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