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/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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:38

ORA-06546：DDL语句在非法上下文中执行,
.原因： DDL语句在非法PL / SQL上下文中动态执行。,
.- PL / SQL中的DDL的动态OPEN游标,
.,
.- 将USING子句中使用的变量绑定到EXECUTE IMMEDIATE DDL,
.,
.- 定义在INTO子句中使用的变量EXECUTE IMMEDIATE一个DDL,
.,
.操作：使用EXECUTE IMMEDIATE而不使用USING和INTO子句来执行DDL语句。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题