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 |
ORA-33080: (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.
DRG-11215: index owner does not have access to filter stored procedure: string
ORA-31107: Action failed as resource "string" is locked by name lock
ORA-00291: numeric value required for PARALLEL option
ORA-14293: Number of partitioning columns does not match number of subpartitioning columns
ORA-27477: "string.string" already exists
LCD-00217: failure while processing file parameter [string]
ORA-31667: parameter name can not be defaulted
ORA-07407: slbtpd: invalid exponent.
PCC-02395: Using arrays of structs requires that the struct be named
EXP-00022: must be SYS or SYSTEM to do incremental export
ORA-39020: invalid mode type string