PLS-00452: Subprogram 'string' violates its associated pragma

PLS-00452: Subprogram 'string' violates its associated pragma
Cause: A packaged function cannot be called from SQL statements unless its purity level is asserted by coding a RESTRICT_REFERENCES pragma in the package specification. The pragma, which is used to control side effects, tells the PL/SQL compiler to deny the packaged function read/write access to database tables, public packaged variables, or both. A SQL statement that violates the pragma will cause a compilation error.
Action: Raise the purity level of the function, or relax the pragma restrictions.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00452：子程序' string '违反其相关的编译指示,
.原因：不能通过SQL语句调用打包函数，除非通过在包规范中对RESTRICT_REFERENCES编译指示进行编码来确定其纯度级别。用于控制副作用的编译指示告诉PL / SQL编译器拒绝对数据库表，公开打包变量或两者的打包函数读/写访问。违反pragma的SQL语句将导致编译错误。,
.行动：提高功能的纯度水平，或者放宽规范限制。,
.

aiaiDBA

13718043309

010-86462881

PLS-00452: Subprogram 'string' violates its associated pragma

1 个回答

相似问题