laptop and a wrench

Bug

Encountering error ORA-00907: missing right parenthesis when attempting to include 'ORDER BY' clause into attribute queries using 'Select by Attributes'.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM045732
SubmittedJune 5, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3.1
Operating SystemOracle Solaris
Operating System Version10
Version Fixed9.2
StatusFixed

Workaround

This functionality only appears to function correctly if both the client and ArcSDE instance are at the 9.3 release or higher.

Steps to Reproduce

Bug ID: NIM045732

Software:

  • ArcSDE/Enterprise Geodatabase

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