ORA-00911: invalid character Toad
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
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.