Skip to Main Content

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!

OracleBulkCopy ODP.net "ORA-16550: truncated result" when writing a double to FLOAT(126) column

User_7BFDBApr 5 2022

I'm encountering error "ORA-16550: truncated result" when writing double's to a FLOAT(126) column, using OracleBulkCopy.
Most values are OK, but some values with high precision fail.
For example, this double works fine: 4.1534934044
But writing this double fails: 19.023493788666666
It is my understanding that FLOAT(126) supports a higher level of precision than a 64 bit float, so why is this truncation issue happening? Is this a bug in ODP.NET?

Comments
Post Details
Added on Apr 5 2022
5 comments
3,200 views