Unsupported DDL Statements in SQL Procedures
You cannot specify the following DDL statements in an SQL procedure.
You also cannot specify any DDL statements in an SQL procedure that administer any aspect of any row-level security constraints.
Note that these statements are restricted from being specified in CREATE PROCEDURE or REPLACE PROCEDURE DDL SQL text, not from being invoked as dynamic SQL from within a procedure definition. Dynamic SQL requests are parsed and bound at run time, not when the procedure that contains them is compiled, so it does not follow the same rules as must be observed when SQL requests are executed from within a compiled procedure. Any SQL statement that can be invoked as standalone dynamic SQL can also be invoked as dynamic SQL from within a procedure definition.