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:

Category(s): Database, Oracle
Tags: , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *