laptop and a wrench


Receive ORA-00932: Inconsistent datatypes when performing Sort Ascending or Sort Descending on a field configured with National Character Large Object (NCLOB) or Character Large Object (CLOB) data type.

Last Published: December 17, 2015 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000086043
SubmittedMarch 12, 2015
Last ModifiedMay 25, 2022
Applies toArcSDE/Enterprise Geodatabase
Version found10.3
StatusKnown Limit

Additional Information

Known limit in Oracle for sorting Large Object (LOB) columns.

Steps to Reproduce

Bug ID: BUG-000086043


  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options