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

    Forum Stats

  • 3,716,128 Users
  • 2,242,960 Discussions
  • 7,845,836 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

Lars Pedersen
Lars Pedersen Member Posts: 21
edited June 2019 in ODP.NET

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

Answers

Sign In or Register to comment.