Oracle Gateways: Datatype converted to LONG in 12c while 10g showing varchar2
(Doc ID 2123618.1)
Last updated on SEPTEMBER 20, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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! |
In this Document
Symptoms |
Cause |
Solution |
References |