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 |
NNO-00801: Error: OCI_SUCCESS_WITH_INFO: string
PLS-00112: end-of-line in quoted identifier
ORA-02260: table can have only one primary key
IMP-00061: Warning: Object type "string"."string" already exists with a different identifier
QSM-00756: the specified workload string is being used by one or more advisor tasks
QSM-02086: mv uses the MIN or MAX aggregate functions
ORA-01073: fatal connection error: unrecognized call type
ORA-19622: archivelog thread string sequence string not restored due to string
ORA-22883: object deletion failed
QSM-02059: join may produce duplicate rows in mv
NNL-00290: Cancelled cache flush
ORA-19020: invalid dereference of XMLType columns