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!

Oracle.DataAccess.Client maps Number(10,0) to both Long and Decimal

Lars PedersenMay 29 2019 — edited Jun 3 2019

In a .NET program, I am using Oracle.DataAccess.Client (from Oracle.DataAccess.dll v. 2.112.1.0) to retrieve data from an Oracle database using a SELECT statement.

2 of the fields are typed as Number(10,0).

In the resulting .NET DataTable object, one of the columns is a Long (Int64) datatype, the other is a Decimal datatype. Why is that?

I found this page that claims that the default datatype mapping from Number(10,0) is Int32:

https://docs.oracle.com/database/121/ODPNT/entityDataTypeMapping.htm#ODPNT8300

Added on May 29 2019

#odp-net

2 comments

246 views