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:
2. Solution
Check if your sql has semicolon at the end of your sql.
My old sql:
My new sql:
Run the sql , everything works fine now.