Error executing: ...
java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement
It comes down to the nuances of various sql clients (ex: sqlplus, sqldeveloper, toad, others). Each of these clients have certain settings which are used by default and lead to a specific user experience. The actions we provide don't specifically try and match any of these these. There are some options that we make available that might make your experience similar. However, all settings that you can set (or are set by default) for the various sql clients may not be settable through the actions available configuration fields.
CA Release Automation v6.6.
Action Name: Run SQL File on Oracle(c) Database Server
The action is okay for running simple statements. Once you start getting into more advanced scripts (for example: nested begin blocks, calling procedures, etc..) then it is recommended to execute your .sql scripts using the "Run Command Line" action configured to call the scripting with your preferred sql client.
The following points are worth nothing while using third party sql clients (for example: sqlplus) to execute your sql scripts via CARA: