Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-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;