漏洞
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.
| 漏洞 ID 编号 | BUG-000142222 |
|---|---|
| 已提交 | August 16, 2021 |
| 上次修改时间 | September 3, 2024 |
| 适用范围 | ArcGIS Pro |
| 找到的版本 | 2.8.2 |
| 操作系统 | Windows OS |
| 操作系统版本 | N/A |
| 状态 | As Designed |
附加信息
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.解决办法
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.
重现步骤
漏洞 ID: BUG-000142222
软件:
- ArcGIS Pro
当漏洞状态发生变化时获得通知
发现关于本主题的更多内容
搜索相关信息
查找与此主题相关的培训
探索想法并提供反馈
获取来自 ArcGIS 专家的帮助
下载 Esri 支持应用程序