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



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

Post New Answer

More Oracle Errors Interview Questions

PLS-00540: object not supported in this context.

1 Answers  


PLS-00586: a static method cannot declare a parameter named SELF

1 Answers  


ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")

1 Answers   Satyam,


TNS-00244: Connection Manager: Request Failed

1 Answers  


CLSS-00200: local node string not listed in configuration

1 Answers  






ORA-06917: CMX: error in data read (too many bytes read)

1 Answers  


ORA-38421: attribute string already exists

1 Answers  


ORA-02376: invalid or redundant resource

1 Answers  


ORA-07587: spdcr: $CREPRC failure

1 Answers  


ORA-26522: rpc execution error

1 Answers  


ORA-15040: diskgroup is incomplete

1 Answers  


ORA-16220: no failed transaction found

1 Answers  


Categories