Friday, December 15, 2006

ORA-00911: invalid character

ORA-00911: invalid character, I've been seeing this error message for 2 long, headache days. What is wrong with my SQL coding?

At first, I thought it was the values that I have inserted were wrong. After much checking, I decided to print out the whole query, copy it and put it into the Oracle SQL client to see what is fxxking wrong.

Test and test and test and retest. No! My query is totally correct to me, but it keep saying that I am wrong, even using Oracle SQL client! So my last resort for this is to remove each of the character in the query one by one. And there is it, the stupid ";" (semicolon) at the end of the query which cause all the misery!

No comments: