Database Error Messages

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

OCI-00904

identifier: invalid identifier
  • identifier: The identifier or column name that was invalid.

Cause

The identifier or column name entered was invalid.


Action

Ensure the following:

  • Enter a valid identifier or column name and verify that there are no typos in the identifier or column name. A valid identifier must begin with a letter, be less than or equal to 128 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks.
  • It must not be a reserved word unless it is enclosed in double quotation marks.
  • If double quotation marks and mixed case were used for a column name when creating the table, then references to that column must use matching case and quotation marks.