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!

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

Comments

Khalil Dahham

I have the same error simply by deploying ORDS on Tomcat locally. I'm using ORDS (21.1.3.153.1102) and Tomcat (10.0.11) installed on windows 10.

User_16TSJ
Answer

I never found the solution for the issue, but I believe it was related to Tomcat 10.x. I downgraded Tomcat to version 9 and the error went away.

Marked as Answer by User_16TSJ · Sep 19 2021
Khalil Dahham

Yes it worked on 9! This will do for now. Thanks.

cormaco

Tomcat 10 is not yet supported by Oracle:
Supported Java EE Application Servers
Application ServerSupported Release
Oracle WebLogic Server 12c Release 2 (from version 12.2.1.3 and later) and 14c Release and later
Apache Tomcat Release 8.5.x through Release 9.0.x

Mohan Poojari

I never found the solution for the issue, but I believe it was related to Tomcat 10.x. I downgraded Tomcat to version 9 and the error went away.

Yes, ORDS will absolutely NOT work on Tomcat 10 today.

1 - 6

Post Details

Added on May 29 2019
2 comments
244 views