Bug
The Oracle database table column created as Number(10,0) – Number, Precision 10, Scale 0 defaults to Long instead of Double in ArcGIS products. The Oracle table holds values more than 2,147,483,647 but returns an "ORA-01455" error in ArcGIS Pro or ArcMap, and opens an empty table.
| Bug ID Number | BUG-000142222 |
|---|---|
| Submitted | August 16, 2021 |
| Last Modified | September 3, 2024 |
| Applies to | ArcGIS Pro |
| Version found | 2.8.2 |
| Operating System | Windows OS |
| Operating System Version | N/A |
| Status | As Designed |
Additional Information
This is by design. ArcGIS interprets a Number(10) data type as a long integer and limit it to 32-bit integers. When creating a double with a precision of 10 and scale of 0 using ArcGIS, ArcGIS treats it as a Double data type. If the data is created outside of ArcGIS as Number(10), it is treated as a long integer.Workaround
In ArcGIS Pro 3.2, 'Big integer' data type can store integers larger than 2.14 billion. Number(11) is interpreted as a big integer. Create the desired column in ArcGIS Pro using the Add Field tool.
Steps to Reproduce
Bug ID: BUG-000142222
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App