Automation Designer shows 'ORA 00911: invalid character' when using multiple statements in an Export Dataset task
Automation Designer shows the error 'ORA-00911: invalid character' when trying to export a dataset from a SQL query with multiple statements. The script can be run from the Editor in Toad without problems. The error occurs when switching between tabs in Export Dataset and when trying to run the export.
The Export Dataset automation task only supports one statement per task.
For multiple statements, please create an Export Dataset task for each.