Bug with OracleClient - overflow error?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ORA 3114 Error with MS .Net provider for oracle 2
OracleConnection error 7
Trying to call a stored procedure from C# (and failing) 8
Issue with Managed Oracle Provider in .NET 3
system.data.oracleclient error 3
OracleDataAdapter.Fill bug? or just not working for me? 2
possible bug in oracleclient 1
MS Oracle .NET Provider and REF CURSOR Error 0

Top