English

FAQ: Does ArcSDE support Oracle's LONG data type?

Question

Does ArcSDE support Oracle's LONG data type?

Answer

Oracle's LONG data type is not supported. Return code -55 (SE_ATTR_CONV_ERROR) displays in the ArcSDE error log files when creating a view containing this data type.

The layer or attribute table containing LONG data type is not viewable in ArcCatalog and the following message appears in the Preview window:

"The selection cannot be previewed."

If adding a layer or attribute containing LONG data type through ArcMap, the following warning message appears:

"Could not add the specified data object to the map."

Instead, use the NCLOB data type that is supported.

Related Information

Last Published: 5/5/2016

Article ID: 000009675

Software: ArcSDE 9.3.1, 9.3, 9.2