PL/SQL: ORA-00984: column not allowed here
I ran into an unexpected error the other day using TOAD. I was trying to add a new column to a table which shouldn’t have been too difficult. It seems that while using that “add column” form that TOAD provides, you still need to put single-quotes around the default value (‘N’) in the default field.
ALTER TABLE users ADD (is_locked CHAR(1 BYTE) DEFAULT N); TOAD was giving me this! Grrr… Useful resources if you like:
- TOAD Handbook (2nd Edition)
- Oracle 11G: SQL
- Oracle Database 11g The Complete Reference
- Beginning Oracle Database 11g Administration: From Novice to Professional