My Oracle Support Banner

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 FEBRUARY 03, 2019

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

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.