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