PLS-00452:Subprogram 'string' violates its associated pragma
错误码
错误描述:Subprogram 'string' violates its associated pragma
错误原因: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.
解决方法:Raise the purity level of the function, or relax the pragma restrictions.
向认证技术专家提问
向技术专家提问


