Question: can ddl statements be used in procedures?
Answer: DDL statements are not allowed in Procedures (PLSQL BLOCK) PL/SQL objects are precompiled. ... On the other hand, DDL (Data Definition Language) statements like CREATE, DROP, ALTER commands and DCL (Data Control Language) statements like GRANT, REVOKE can change the dependencies during the execution of the program.