Showing posts with label ORA-06546: DDL statement is executed in an illegal context. Show all posts
Showing posts with label ORA-06546: DDL statement is executed in an illegal context. Show all posts

Sunday, 5 February 2012

ORA-06546: DDL statement is executed in an illegal context

ORA-06546: DDL statement is executed in an illegal context

Cause: DDL statement is executed dynamically in illegal PL or SQL context. - 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.