ODP.NET or OCI application may return wrong data type (or precision or scale) for GROUP BY statement
Last updated on NOVEMBER 30, 2016
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database - Standard Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Running a GROUP BY query from ODP.NET or OCI application against 18.104.22.168 database may return
unexpected (wrong) data type for some selected column.
Following are some examples.
When obtaining column type, GetType().ToString() which used to return System.Int16 in 11.2.0
returns System.Decimal in 22.214.171.124.
OCI application which prints OCI_ATTR_DATA_TYPE, OCI_ATTR_PRECISION, and OCI_ATTR_SCALE
returns wrong precision/scale information on 126.96.36.199. For example:
Upgraded the database server from 11.2 to 12.1.
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 hundreds of Community platforms