English

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