ORA-00911
character_value: invalid character after token_value
- character_value: The invalid character causing the error.
- token_value: The token after which the invalid character causing the error occurs.
Cause
An invalid character has been encountered in the SQL statement.
Action
Remove the invalid character. If it is part of an identifier, enclose the identifier in double quotation marks.
Additional Information
The identifier can only consist of letters, numbers and the
special characters $, # and _. However, these special
characters cannot be at the beginning of the identifier.
Identifiers can include characters other than $, # and _ if
these characters are enclosed in double quotation marks.
For example, the following SQL statement contains an invalid
identifier user~id:
SELECT user~id FROM users;
However, the identifier is valid if enclosed in double quotation marks. For example:
SELECT "user~id" FROM users;