Total Pageviews


Solution to ORA-00911(invalid character, 字元無效)

As I would like to execute an insert SQL statement, it throws ORA-00911 error. After googling, it recommend to "remove the invalid character from the statement or enclose the object name in double quotation marks". 
But the insert SQL statement is working fine in SQL Developer, only failed in java program.

Remove the semi-colon in the end of SQL statement.

No comments: