Justine,
That's because the ALTER TABLE statement is a DDL statement. You will have to use Dynamic SQL to execute it from within a stored procedure.
Something like:
EXECUTE IMMEDIATE 'ALTER TABLE controls_pbis ADD project_5 varchar2(5)' ;
for Oracle 8i and above, or use DBMS_SQL package.
Cheers,
Prat
|