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

Hi Njal,

Yes, this was the problem. It's a puzzle that the Char column broke but the Number column did not. The number column had a default also.

--

Jim Poe (jpoe_at_fulcrumit.com)
<n.a.ekern_at_usit.uio.no> wrote in message news:9s75ib$2bb$1_at_readme.uio.no... 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) Received on Tue Nov 06 2001 - 12:26:31 CST