Bug
Opening an attribute table after executing a query in definition query on Shape.Area results in error ORA-00904.
| Bug ID Number | NIM058852 |
|---|---|
| Submitted | July 7, 2010 |
| Last Modified | April 2, 2025 |
| Applies to | ArcSDE/Enterprise Geodatabase |
| Version found | 10.0 |
| Version Fixed | N/A |
| Status | Fixed |
Workaround
Workarounds:#1 Execute definition queries against the SHAPE.AREA or Length columns as: "sde.st_length(shape)> n" or sde.st_area(shape)> n"#2 Create a new field as "double" and use Field Calculator to populate it with SHAPE.AREA values. Create definition queries against this new field.Steps to Reproduce
Bug ID: NIM058852
Software:
- ArcSDE/Enterprise Geodatabase
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App