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 NOVEMBER 24, 2010
Applies to:Oracle ODBC Driver - Version: 220.127.116.11 to 18.104.22.168 - Release: 11.1 to 11.2
PL/SQL - Version: 22.214.171.124 to 126.96.36.199 [Release: 11.1 to 11.2]
Information in this document applies to any platform.
will return wrong Type (Only ODBC - SQL_FLOAT/SQL_DOUBLE returned instead SQL_DECIMAL ), Precision and Scale (ODBC and PL/SQL)
ALTER TABLE <table_name> ADD (<column_name> NUMBER (P,S))
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