laptop and a wrench

Bug

The Find and Replace function returns an error, "ORA-00904" when searching for a value in a feature class with SDO_GEOMETRY.

Last Published: April 8, 2016 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000085945
SubmittedMarch 9, 2015
Last ModifiedJune 5, 2024
Applies toArcSDE/Enterprise Geodatabase
Version found10.2
Operating SystemWindows OS
Operating System Version7 64 Bit
StatusWill Not Be Addressed

Additional Information

SDO_Geometry data type does not contain the columns of shape.len and shape.area. However these columns are needed by ArcGIS for consistency. Please exclude these columns from calculations or searches.

Workaround

- Select the column header before searching for the value. - Store the data in another format, such as ST_Geometry.

Steps to Reproduce

Bug ID: BUG-000085945

Software:

  • 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