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 FEBRUARY 05, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterOracle Database Gateway for SQL Server - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
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
[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
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 |
Changes |
Cause |
Solution |
References |