DBMSEXECUTE returns 'sql statement failed to parse'

Last Published: April 25, 2020

Solution or Workaround

DBMSEXECUTE fails with the following message:

      sql statement failed to parse  


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.


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

&sys isql -Uuser -Ppassword < sqlfile

You may also type:

&sys sqlplus user/password @sqlfile

Article ID:000001461

  • Legacy Products
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic