ORA-00911: invalid character Toad

Question

I am using Toad 11.5

when I run multiple truncate statement, it gives an error ORA-00911: invalid character

truncate table employees;
truncate table employees_edit_history;
truncate table sourcecontributioncalc;

but when I run it one bye one , it execute successfully! Why toad giving an error when I run all statements once?

and any solution for that ?

Answer 1

When you run it as a statement (F9) you can't have multiple statements, and the semicolons are meaningless - as they are statement separators. (You get the same error with a semicolon in an execute immediate or JDBC call, for example, as they only support a single statement).

If you run as a script (F5) instead then those separators do have meaning, and the multiple statements that they, er, separate will be executed in sequence.