DemersM

Bug report in arcgis when trying to sort an Oracle NCLOB field

Discussion created by DemersM on Sep 21, 2016
Latest reply on Dec 19, 2018 by timmytim

In a SDE GeoDatabase on Oracle, if you set the text field size larger than 2,000 and the database is set to use Unicode encoding, the Oracle data type will be NCLOB. (See: Oracle data types supported in ArcGIS—Help | ArcGIS for Desktop )

 

In ArcGis, if you open the table and try to sort this CLOB field you have the following error:

 

There was a problem sorting

Underlying DBMS error [ORA-00932: inconsistent datatypes: expected - got NCLOB]

Outcomes