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!

Why is my 29 digit number being altered when filling a datatable using Oracle.ManagedDataAccess.dll?

2668846May 7 2014

Hello,

I have a 10g database with some numbers(30,0) and when I fill my datatable with a Decimal datacolumn type it's getting altered. The specific value I'm having problems with is 31724977359034458496430204230 getting changed to 3172497735903445849643020435. I can work around this by wrapping my queries with a TO_CHAR() but I'm concerned with performance.

I think the answer lies somewhere in the DecimalConv.GetDecimal(rawData, dataOffset, dataLength)

Also, this seems to be happening just when the column is a primary key. The foreign key with the same value is retrieved correctly.

Any insight is helpful!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2014

Added on May 7 2014

#odp-net

0 comments

787 views