All Oracle Error CodesOracle DBA Forum

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 variable's used in USING clause to EXECUTE IMMEDIATE a DDL

- Define variable's used in INTO clause to EXECUTE IMMEDIATE a DDL


Action: Use EXECUTE IMMEDIATE without USING and INTO clauses to execute the DDL statement.