PLS-00103 error using Alter Table command

[akkerend]

In 8.0 you can use procedure EXEC_DDL_STATEMENT in package DBMS_UTILITY.

OPEN mytbl_cursor;
FOR i IN 1..v_count LOOP
FETCH mytbl_cursor INTO n_abbr;
EXIT WHEN mytbl_cursor%notfound;
dbms_utility.exec_ddl_statement('ALTER TABLE cmbc_tmptrips2 ADD('||n_abbr||' varchar2(10))');
dbms_output.put_line(n_abbr);
END LOOP;
CLOSE mytbl_cursor;