ORA-00911 Invalid Character Error using Execute SQL Step

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.

Applies to: