others-How to solve ORA-00911 invalid character problem
1. The purpose of this post
Sometimes, when we copy and paste sql scripts from sqlplus or plsql to java programs, we get this exception or error like this:
ORA-00911: invalid character found in sql...
2. Solution
Check if your sql has semicolon at the end of your sql.
My old sql:
insert into tablea(aaa) values('111');
My new sql:
insert into tablea(aaa) values('111')
Run the sql , everything works fine now.