漏洞
ArcGIS double fields with precision 10 and scale 0 in an Oracle geodatabase are altered automatically to long integer after previewing it in ArcGIS Desktop 10.6.1, ArcGIS Pro 2.2 or later clients. An error message, "[ORA-01455: converting columns overflows integer datatype]" is returned if the fields contain numbers larger than the maximum for a long integer (2,147,483,647).
| 漏洞 ID 编号 | BUG-000118138 |
|---|---|
| 已提交 | November 13, 2018 |
| 上次修改时间 | May 31, 2023 |
| 适用范围 | ArcGIS for Desktop |
| 找到的版本 | 10.6.1 |
| 服务器平台 | Windows OS |
| 客户端平台 | 2016 64 Bit |
| Version Fixed | 2.5.2 |
| 状态 | Fixed |
附加信息
The error is expected when a column is created with the data type 'double', precision 10 and scale 0, and stores a value greater than 32-bit integer limit, i.e. 2,147,483,647. A column with the data type 'double' and the precision 0, maps to the Oracle data type NUMBER(10). In ArcMap 10.2.1, this column was mapped with ArcMap the data type 'double' which allowed storing values greater than 2,147,483,647. The mapping has been corrected to represent NUMBER(10) as long integers. Thus, values greater than 2,147,483,647 are no longer allowed.解决办法
The ArcGIS (Desktop, Engine, Server) Oracle Data Type Patch is now live on the support site. The URL is: https://support.esri.com/en/download/7785.
重现步骤
漏洞 ID: BUG-000118138
软件:
- ArcGIS for Desktop
从 ArcGIS 专家处获得帮助
下载 Esri 支持应用程序
发现关于本主题的更多内容
搜索相关信息
查找与此主题相关的培训
探索想法并提供反馈