PLS-00103-issues with running alter table during stored procedures

PLS-00103-Problems with running alter table during stored procedures the following error occurs when running alter table during stored procedures: www.2cto.com Compilation errors for PROCEDURE. UNDOMERCHANTACCOUNT Error: PLS-00103: Encountered the symbol "ALTER" when expecting one of the following: begin case declare end exception exit for goto if loop modnull pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> <close current delete fetch lock insertopen rollback savepoint set SQL execute commit forall mergepipeLine: 21 Text: alter table TBL_TEST storage (buffer_pool default); solution: dynamic SQL: SQL code execute immediate 'alter table XXX ';