Bug with OracleClient - overflow error?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top