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

LPX-00223: external entity "~s" found in an attribute value

1 Answers  


ORA-00290: operating system archival error occurred. See error below

1 Answers  


ORA-01692: unable to extend lob segment string.string partition string by string in tablespace string

1 Answers  


PLS-00049: bad bind variable 'string'

1 Answers  


ORA-28028: could not authenticate remote server

1 Answers  


DRG-11116: value of string must be less than or equal to value of string

1 Answers  


ORA-07646: sszfck: $CREATE failure

1 Answers  


PCC-00038: Unable to open a cursor

1 Answers  


ORA-01230: cannot make read only - file string is offline

1 Answers  


ORA-24758: not attached to the requested transaction

1 Answers  


ORA-12208: TNS:could not find the TNSNAV.ORA file

1 Answers  


SQL*Loader-00416: SDF clause for field string in table string references a non existent field.

1 Answers  


Categories