Tuesday, May 16, 2017

ORA-00911: invalid character 00911. 00000 - "invalid character"

Error: ORA-00911: invalid character
00911. 00000 -  "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:

You might get this error while executing SQL queries

Use the CONVERT function to convert the query string and try again, I hope it should work

To get more details on CONVERT function use please see:  Convert Function

No comments:

Post a Comment