My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.