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 |
TNS-12236: TNS:protocol support not loaded
LPX-00402: invalid axisname in the XSL file
ORA-01546: tablespace contains active rollback segment 'string'
NID-00415: Change of database name and database ID failed.
ORA-00202: controlfile: 'string'
PLS-00133: Pragma string expects 1st argument to be an identifier or string-literal
ORA-38612: FI item length cannot exceed half of one database block.
NZE-29249: an unrecognized state was passed to a cryptographic function
ORA-07594: spiip: $GETJPIW failure
SQL*Loader-00469: SID directive expects 1 argument, number found.
ORA-07758: slemcw: invalid handle
ORA-07549: sftopn: $OPEN failure