No yours does not work either..

EXECUTE ALTER_TABLE_ADD ('ETTIMELINE', 'TL_INVC_STS', 'NUMBER DEFAULT 20');


Its the DEFAULT in the execute immediate statement that makes it fail !! In yours and mine too...it will not give you error when you add the column using above statement, it will fail when you use it in other procedure for DML.

How do I get it to work ?

When I create this procedure which uses that column that I just added...

CREATE OR REPLACE PROCEDURE pr_addInvoice
(---inpit parameters--- )
IS
--variables--

Begin
if inYES = 20 then

-- statements--

/*update the Invoice Status in the ETTimeLine Table*/
update ETTimeLine
set TL_Invc_Sts = 10
WHERE TL_ID in
(select Mat_TL_ID
FROM mwebmatrix
where Mat_ID in (select distinct InvItem_Mat_ID
from mwebInvoiceItem
where InvItem_Inv_ID = inInv_ID and InvItem_Type=10));

End if;
-- statements--
Commit;
End pr_addInvoice;
/
I get this error

MGR-00072: Warning: PROCEDURE PR_ADDINVOICE created with compilation errors.
SQLWKS>
SQLWKS> show errors
Errors for PROCEDURE PR_ADDINVOICE:
LINE/COL ERROR
--------------------------------------------------------------------------------
731/6 PLS-00417: unable to resolve "TL_INVC_STS" as a column
730/2 PL/SQL: SQL Statement ignored




Thanks
Sonali