ODBC/PLSQL: Wrong Type, Precision and Scale Returned For Column of Type Number(P,S) Added by ALTER TABLE Statement
(Doc ID 1241794.1)
Last updated on FEBRUARY 22, 2019
Applies to:PL/SQL - Version 220.127.116.11 to 18.104.22.168 [Release 11.1 to 11.2]
Oracle ODBC Driver - Version 22.214.171.124 to 126.96.36.199 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Using one of the following methods
will return wrong Type (Only ODBC - SQL_FLOAT/SQL_DOUBLE returned instead SQL_DECIMAL ), Precision and Scale (ODBC and PL/SQL)
Upgrading DB from pre-11gR1(10.2.0.5 and lower) to 11gR1 (11.1.0.X) or 11gR2 (188.8.131.52).
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 Changes Cause Solution References
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.