Querying a map service with the 'Order By' parameter results in the following error, "Failed to execute query." The failure occurs when the 'Order By' parameter is used on a text field from an Oracle database with 2001 or more characters allowed.
上次发布: August 3, 2016ArcGIS for Desktop
漏洞 ID 编号
BUG-000096483
已提交
May 16, 2016
上次修改时间
June 5, 2024
适用范围
ArcGIS for Desktop
找到的版本
10.2.2
操作系统
Windows OS
操作系统版本
2012
状态
Known Limit
经开发团队审核,已确定此问题与不受 Esri 控制的软件的已知限制有关。 问题的“其他信息”部分可能包含进一步说明。
附加信息
This behavior is as designed. Ordering by NCLOB (or any other LOB data types) is not supported in Oracle databases. For more information, refer to the document available from the following link, http://bit.ly/2ahHWOk.
When creating a text field larger than 2000 characters as Unicode, it gets mapped to NCLOB, as stated in the document from the following link, http://arcg.is/2akZQ01.