Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00452: Subprogram 'string' violates its associated pragma
- 1 Answers
- 3612 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-14326: Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
ORA-29869: cannot issue ALTER without REBUILD on a domain index marked FAILED
PLS-01501: Options in CREATE TABLE statement is non-ANSI.
ORA-32113: Null object passed
ORA-22064: invalid NLS parameter string [string]
RMAN-06210: List of Mismatched objects
ORA-14013: duplicate partition name
ORA-28523: ORACLE and heterogeneous agent are incompatible versions
ORA-07268: szguns: getpwuid error.
LSX-00311: local element or attribute shouldn't be namespace qualified
PLS-00580: supertype must be an object type
ORA-15002: parameter LOCK_NAME_SPACE exceeds limit of string characters
Oracle Errors 
