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 MARCH 04, 2022
Applies to:
PL/SQL - Version 11.1.0.6 to 11.2.0.1 [Release 11.1 to 11.2]Oracle ODBC Driver - Version 11.1.0.6 to 11.2.0.1 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Symptoms
Using one of the following methods
- ODBC
will return wrong Type (Only ODBC - SQL_FLOAT/SQL_DOUBLE returned instead SQL_DECIMAL ), Precision and Scale (ODBC and PL/SQL)
Changes
Upgrading DB from pre-11gR1(10.2.0.5 and lower) to 11gR1 (11.1.0.X) or 11gR2 (11.2.0.1).
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 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.