PLS-00452: Subprogram 'string' violates its associated pragma
- 1 Answers
- 2930 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 |
IMG-00544: invalid compressionQuality specified
ORA-24122: invalid block range specification
TNS-00298: Request to Navigator: string
TNS-00087: * version - ask the process name to display its version number
ORA-00354: corrupt redo log block header
PCC-00077: Colon usage with numeric label in WHENEVER statement is not ANSI
ORA-13251: duplicate entry string in metadata table
NNL-00542: restart [<server_list>] : restart one or more Names servers
ORA-14189: this physical attribute may not be specified for an index subpartition
PCC-00027: Redeclared SQL Identifier "string" at line number in file string
NNL-00913: Server-generated requests sent: number
TNS-12611: TNS:operation is not portable
Oracle Errors 
