Originally posted by Raminder
DDL commands are not allowed directly into a stored procedure.
Really? Do you mean not at all, or only if you use something like execute_immediate, dbms_sql, or something along those lines?