Bug with OracleClient - overflow error?

microsoft.public.dotnet.framework.adonet

27 Feb 2006 8:41 PM

Chavdar

I have an Oracle query with a NUMBER(30) field in it (EMPLOYEE_ID).

When I try to Fill a DataTable with a OracleDataAdapter using just a plain
query like:

SELECT * FROM EMPLOYEE

I get:
System.Data.OracleClient.OracleException: OCI-22053: overflow error

   at System.Data.OracleClient.OracleException.Check(OciErrorHandle
errorHandle, Int32 rc)
   at System.Data.OracleClient.OracleNumber.ToUInt32(OciErrorHandle
errorHandle, Byte[] value)
   at System.Data.OracleClient.OracleNumber.ToDecimal(OciErrorHandle
errorHandle, Byte[] value)

Why is the framework trying to convert the value to UInt32 when it should be
a Decimal with a much higher range? Why is ToDecimal calling a ToUInt32? This
seems like a bug in System.Data.OracleClient.OracleNumber.ToDecimal.

Thanks