Max decimal value handled by DotConnect?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 4
Joined: Tue 25 May 2010 08:37

Max decimal value handled by DotConnect?

Post by prr1234 » Thu 01 Jul 2010 08:43


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,

Site Admin
Posts: 8240
Joined: Thu 14 Aug 2008 12:44

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.

Post Reply