Title :
ORA-06546 DDL statement is executed in an illegal context
Cause :
DDL statement is executed dynamically in illegal PL/SQL context.
- Dynamic OPEN cursor for a DDL in PL/SQL
- Bind variables used in the USING clause to EXECUTE IMMEDIATE a DDL
- Define variables used in the INTO clause to EXECUTE IMMEDIATE a DDL
Action :
Use EXECUTE IMMEDIATE without USING and INTO clauses to execute the DDL statement.