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:
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.