Oracle Gateways: Datatype converted to LONG in 12c while 10g showing varchar2 (Doc ID 2123618.1)

Last updated on AUGUST 04, 2018

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.