Query Using TG4MSQL Seems To Hang; NCHAR/NVARCHAR Column Mapping Causes WHERE Stripped Off
(Doc ID 456400.1)
Last updated on DECEMBER 03, 2014
Applies to:Oracle Database Gateway for SQL Server - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
Oracle Transparent Gateway for Microsoft SQL Server - Version: 10.2.0.1.0 to 10.2.0.5.0
Querying a SQLServer table using the Transparent Gateway for SQL Server 10.2 hangs using the following simple query:
However following query on the same table returns results quickly:
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