ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODP.NET managed driver - cannot read decimal values correctly

AGanaJul 19 2016 — edited Sep 13 2016

Hallo,

We use Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production. I have a problem with ODP.NET managed driver (version 12.1.24160419). I am trying to read a decimal value from a table. In table it is declared as NUMBER (no scale and no precision specified). When I read it using EF, the framework tries to cast it to decimal but cannot do, so gives "casting specified not valid" error. The original value from table is 0.000000000000000888178419700125. I get this problem only for this row and the values from the other rows are read properly. Could anyone help me in this?

Thanks in advance.

Regards,

AGana

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2016

Added on Jul 19 2016

#odp-net

4 comments

2,565 views