Question / Problem:
Execute SQL Step generates an error:
ORA-00911 error - Invalid character error
Answer / Solution:
An Execute SQL step permits a single SQL statement execution.
Review the step and verify that only one SQL statement exists and there is no semi-colon (;) at the end of the statement.
If the robot needs to run multiple queries add multiple Execute SQL steps, each with one query.
Also, COMMIT; is not needed in Execute SQL steps.