Oracle Gateways: Datatype converted to LONG in 12c while 10g showing varchar2

(Doc ID 2123618.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Setup used

Gateway: Oracle gateways for ODBC 12.1.0.2
Odbc Driver Manager : unixODBC-2.3.4
Sqlserver Driver: msodbcsql-11.0.2270.0
Linux Redhat 6.5

Varchar2 column is shown as long when accessed via 12c gateways.
In Oracle 12c

desc dbo.XYZ@R;


Name Null? Type
----------------------------------------- -------- ----------------------------
OU                    LONG
OUDesc             VARCHAR2(75 CHAR)
MonthEndDat     DATE

The same setup with Oracle 10g

desc dbo.XYZ@R;

Name Null? Type
----------------------------------------- -------- ----------------------------
OU                 VARCHAR2(8192 CHAR)
OUDescription VARCHAR2(75)
MonthEndDate DATE

 

Even after setting
HS_KEEP_REMOTE_COLUMN_SIZE = LOCAL, there is no change in varchar2 column size

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