Max decimal value handled by DotConnect?
Posted: Thu 01 Jul 2010 08:43
Hi,
we recently verified our oracle database and found values in one of the NUMBER columns to be like 1.3123123123123E69 etc. this column is handled as a DOUBLE on the client side.
the maximum value in .net is decimal which is 128 bit and can hold a max value of 79,228,162,514,264,337,593,543,950,335. however, the values we found in the database are a way higher than this. while reading this value DOTCONNECT is simply truncating (for ex: 1.3123123123123E69, it reads as 1.31231231231231).
we have a different client running on the same database to read values and is using ORACLE DATA PROVIDER. when this client encounters to read this value, it simply through Arithmatic overflow exception.
I am wondering how this value got manged to entered to the database through DOTCONNECT?
Thanks In Advance,
Prabhakar.
we recently verified our oracle database and found values in one of the NUMBER columns to be like 1.3123123123123E69 etc. this column is handled as a DOUBLE on the client side.
the maximum value in .net is decimal which is 128 bit and can hold a max value of 79,228,162,514,264,337,593,543,950,335. however, the values we found in the database are a way higher than this. while reading this value DOTCONNECT is simply truncating (for ex: 1.3123123123123E69, it reads as 1.31231231231231).
we have a different client running on the same database to read values and is using ORACLE DATA PROVIDER. when this client encounters to read this value, it simply through Arithmatic overflow exception.
I am wondering how this value got manged to entered to the database through DOTCONNECT?
Thanks In Advance,
Prabhakar.