The error seems to mean that Toad is including the trailing semicolon as part of the command, which. ERROR] SQL State : 2 [ ERROR] Error Code : 911 [ ERROR] Message : ORA - 00911: invalid character Taken from the Flyway First Steps. D SQLSTATE Codes. This appendix contains a table of the SQLSTATE codes and the. Code, Condition, Oracle Error. Code: Select all: SQL Error [ 911] [ 2] : ORA- 00911: invalid character. Side note: keyboard shortcut ctrl+ c of the log and the error message. The reason for this error is that Oracle sees a character that it considers invalid. If you use a special character in a table or column name, then try putting double. The ORA- 00911 error message, described as an invalid character error,. can be from starting identifiers with ASCII ( American Standard Code) that are not. SQL> begin 2 execute immediate ' update scott. emp set sal = sal * 1. 1 where deptno= 10; ' ; 3 commit; 4 end; 5 / begin * ERROR at line 1: ORA- 00911: invalid. Learn the cause and how to resolve the ORA- 00911 error message in Oracle.
You tried to execute a SQL statement that included a special character. I suspect you want to put the whole thing in an anonymous PL/ SQL block and run that, i. BEGIN INSERT INTO E_ PRODUCT VALUES ( ' PCD2', ' PC Dual Core'.