Database   Sql   Functions   Packages   Performance   Books   Oracle   Other   About   XML   ORA-messages

Common error messages

TNS connection closed
IO error writing block
Resource busy
Invalid character
Invalid datatype
Syntax error
Looping chain synonyms
Resolve connect identifier
number too large for buffer
All error messages


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 doublequotes may contain any character other than a doublequote. Alternative quotes (q"#...#") cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL Language Reference Manual.
Action: none
The reason for this error is that Oracle sees a character that it considers invalid. If you use a special character in a table or column name, then try putting double quotation-marks around the name. If you use a special character in a value, put quotation marks around it. Could also be that you have a non-printable character in your query that you do not see (maybe from copy/paste). Try manually typing in the sql. Another reason could be that you forgot a single quote somewhere in your query.