ERROR

ORA-00933: SQL command not properly ended

Last Published: April 25, 2020

Error Message

When working with Oracle spatial layers, the following error is returned:

"Underlying DBMS error[ORA-00933: SQL command not properly ended

::SQL Expression... << SELECT ... WHERE mdsys.sdo_filter(...) = 'TRUE' WHERE ((...))>> ..."

Cause

The Oracle error ORA-00933 can occur with Oracle Spatial layers when:

1. Joining the Oracle Spatial layer to another table,
2. Setting an ArcMap "Definition Query" on an Oracle Spatial table, or
3. Trying to draw or perform spatial searches on the Oracle Spatial layer, such as ArcMap "Identify".

Solution or Workaround

Upgrade to ArcSDE/ArcGIS 8.1 SP1.

    Article ID:000004032

    Software:
    • Legacy Products

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic