Page Comparison

This article discusses three different ways to disable SQL Parser

Why disable SQL

...

Parser?

It may be necessary to disable SQL Parser if your get false failures (SQL Parser incorrectly fails forecast).

...

1. Open your project

2. Browse to settings tab

3. Expand “Deployment Setting” and uncheck the box for “Enable Oracle SQL Parser”

   1. Image RemovedImage Added

4. Be sure to commit your project back to you Git repository.

...

1. In you favorite text editor open your changelog.xml file from your Datical repository

2.  Find the relevant changeset where you want to disable SQL Parser.

3. Add disableSqlParser=”true” in the changeset, as follows:

   1. Code Block

      <changeSet appdba:scriptChecksum="9f8a11051d1478faf2752baacb76cf0e" author="AmyJ SmithDoe" created="2020-08-10 18:37+0000" datical:origFileName="adding_test_data_new_001.sql" datical:origFilePath="90_data_manipulation/CACCOREscripts/sql_direct" datical:version="1" datical:versionStrategy="DEPLOY_ALL" id="20200810183704986_adding_test_data_new_001" labels="509,deploy-test1,deploy-test1,adding_test_data_new_001.sql"> <appdba:sqlplus disableSqlParser="true" enableRollbackOnError="true" path="data_dmlsql/20200810183704986_adding_test_data_new_001.sql" removeSpools="First" schemaName="CACCORESCHEMA1"/> <comment>Adding<comment>Test test data<script</comment> </changeSet>

4. Save your file.

5. Be sure to commit your project back to you Git repository.

Related articles

...

1. your Git repository.