ODP.NET or OCI application may return wrong data type (or precision or scale) for GROUP BY statement (Doc ID 2209002.1)

Last updated on NOVEMBER 30, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database - Standard Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Running a GROUP BY query from ODP.NET or OCI application against 12.1.0.2 database may return
unexpected (wrong) data type for some selected column.

Following are some examples.

 

ODP.NET

When obtaining column type, GetType().ToString() which used to return System.Int16 in 11.2.0
returns System.Decimal in 12.1.0.2.

 

OCI

OCI application which prints OCI_ATTR_DATA_TYPE, OCI_ATTR_PRECISION, and OCI_ATTR_SCALE
returns wrong precision/scale information on 12.1.0.2.  For example:

On 11.2.0.4

 

 

Changes

Upgraded the database server from 11.2 to 12.1.

 

Cause

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