OCI-00911
'character_value': invalid character after 'previous_keyword_values'
- character_value: The invalid character causing the error.
- previous_keyword_values: A sequence of keyword values that immediately precede the character_value in the command. The sequence of previous keyword values may be truncated if it is too long.
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;