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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

238 views