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 |
IMG-00561: input format does not support channel selection
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
SQL-02102: Inconsistent cursor cache. No global cursor entry.
ORA-24281: invalid access past the maximum size of LOB parameter string
RMAN-06038: recovery catalog package detected an error
ORA-14505: LOCAL option valid only for partitioned indexes
ORA-13368: simple polygon type has more than one exterior ring
ORA-00238: operation would reuse a filename that is part of the database
ORA-01595: error freeing extent (string) of rollback segment (string))
ORA-02360: fatal error during data export/import initialization
PLS-00990: Index Tables of Cursor Variables are disallowed
DRG-51025: an invalid character was passed to the stemmer