laptop and a wrench

Bug

'Select by Attributes' with 1-to-many relationships returns no results with spatial view and errors with ORA-00936: missing expression.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM036495
SubmittedJuly 1, 2008
Last ModifiedApril 2, 2025
Applies toNo Product Found
Version found9.3
Version Fixed9.3
StatusFixed

Workaround

Export the spatial view as a layer so there are unique objectids assigned.

Steps to Reproduce

Bug ID: NIM036495

Software:

  • No Product Found

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options