Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00452: Subprogram 'string' violates its associated pragma
- 1 Answers
- 3685 Views
- I also Faced
- E-Mail Answers
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 |
PCC-00011: Already in a declare section at line number in file string
ORA-12997: cannot drop primary key column from an index-organized table
ORA-16090: archive log to be replaced not created by managed standby process
ORA-28039: cannot validate Kerberos service ticket
NZE-29101: Cannot add private key bag.
IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created
ORA-14037: partition bound of partition "string" is too high
ORA-38104: Columns referenced in the ON Clause cannot be updated: string
ORA-37115: New OLAP API history is not allowed
ORA-19801: initialization parameter DB_RECOVERY_FILE_DEST is not set
ORA-07594: spiip: $GETJPIW failure
PLS-00142: duplicate external PARAMETER list specification in subprogram expression
Oracle Errors 
