Friday, November 16, 2012

ORA-00911: invalid character


This one is simple, but useful.  :)

When compile  a VIEW, the error "ORA-00911: invalid character" poped up.

@biprd_abc.com> @/dev/SQL/v_nov09.sql
    AND f.COL_ABC not in
                          *
ERROR at line 444:
ORA-00911: invalid character

=====
 not in
 not in
========

Copy above 2 "not in" into a text editor, you'll see the invisible Special Character.
TextWrangler can show the invisible Special Characters.  I couldn't find this function in SubLime Text 2.

The solution is simple too: remove the string contains Special Character, and then type them again.


Thanks,
Charlie

Post a Comment