Re: PLS-00417: unable to resolve <string> as a column

Hi!

Do you happen to have Update-triggers on the Office-table? Try disabling them before you add the column (default 'E' Not Null will update every existsing row to 'E')
Or try to add the column as Null, update rows to E and modify to Not Null.

Regards,
Njål A. Ekern

Jim Poe (jpoe_at_fulcrumit.com):
This is part of the script that was run in SQLPlus

ALTER TABLE OFFICE
 ADD ( AP_DUE_BASE CHARACTER(1) DEFAULT 'E' NOT NULL);

--
Jim Poe (jpoe_at_fulcrumit.com)