Skip to main content
Kofax

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:  

Product Version Category

Kapow

RPA

9.x

10.x

 
 
  • Was this article helpful?