Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00452: Subprogram 'string' violates its associated pragma
- 1 Answers
- 3593 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 |
ORA-12926: FORCE LOGGING option already specified
ORA-29823: object being analyzed is not a table
AMD-00138: level names parameter not null or defaulted
PLS-00104: empty argument list in call of procedure 'string' must be omitted
SQL*Loader-00943: incorrect datafile string specified for table string partition string
RMAN-06727: could not locate datafilecopy string
RMAN-08052: cataloged controlfile copy
IMG-00807: no weights specified in weight string
ORA-12645: Parameter does not exist.
ORA-14631: the partition bounds do not match the subpartition bounds of the partition
ORA-16577: corruption detected in Data Guard configuration file
ORA-38720: Missing log file number.
Oracle Errors 
