Error: ORA-00933: SQL command not properly ended

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 ((...))>> ..."


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.