Recently I got this error “ORA-00911: invalid character\n” When I was working with Oracle and Asp.net.I was just gone mad bcoz release coming closer and suddenly started getting this error.
I first thought it was due to “\r\n” character which getting created due to blank spaces.
Then I checked for singled out special character in query .. but no luck …. 😦
then as per Oracle – ORA-00911: invalid character
Cause: identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after the first character. Identifiers enclosed by double quotes may contain any character other than a double quote. Alternative quotes (q”#…#”) cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL Language Reference Manual. Action: none
But then I got One stupid mistake I have done forgot removing ” ; ” at end of the query
after removing ” ; ” at last problem got solved. so be carefulll…..