Max decimal value handled by DotConnect?

prr1234 · Post by **prr1234** » 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.

Shalex · Post by **Shalex** » Mon 05 Jul 2010 15:05

1. Could you please send us a small test project with the DDL script to reproduce the problem? Because we need information about the column definition, the way you are inserting and retrieving data. Please show us how you inserted one value, it transformated in different value in database, and truncated during select.

2. Also please specify the exact versions of your dotConnect for Oracle (the Tools > Oracle > About menu of Visual Studio), Oracle Client and Oracle Server.