Error: DBMSEXECUTE Returns 'Sql Statement Failed to Parse'

Solution or Workaround

DBMSEXECUTE fails with the following message:

      sql statement failed to parse

Cause:

The DBMS-specific statement is not understood by the ARC/SQL lexicon. ArcInfo tries to parse the SQL statement with DBMSEXECUTE commands. If it is a non-SQL statement (it is DBMS specific), ArcInfo is not able to parse the statement.

Solution:

Create a simple text file (example: sqlfile) with the DBMS SQL statement using the AML [WRITE] function. To run the statement from Arc type:

Code:
&sys isql -Uuser -Ppassword < sqlfile

You may also type:

Code:
&sys sqlplus user/password @sqlfile

Article ID:000001461

Software:

Legacy Products
ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

DBMSEXECUTE returns 'sql statement failed to parse'

Solution or Workaround

Discover more on this topic