PLS-00452: Subprogram 'string' violates its associated pragma
Answer / guest
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.
Please add more information about this Error
Is This Answer Correct ? | 1 Yes | 0 No |
PLS-00540: object not supported in this context.
PLS-00586: a static method cannot declare a parameter named SELF
ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
TNS-00244: Connection Manager: Request Failed
CLSS-00200: local node string not listed in configuration
ORA-06917: CMX: error in data read (too many bytes read)
ORA-38421: attribute string already exists
ORA-02376: invalid or redundant resource
ORA-07587: spdcr: $CREPRC failure
ORA-26522: rpc execution error
ORA-15040: diskgroup is incomplete
ORA-16220: no failed transaction found