PLS-00452: Subprogram 'string' violates its associated pragma
- 1 Answers
- 3256 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-01877: string is too long for internal buffer
ORA-31015: Attempted to insert entry without name
ORA-12702: invalid NLS parameter string used in SQL function
LPX-00219: invalid digit '~c' in character reference
ORA-01611: thread number string is invalid - must be between 1 and string
LSX-00204: extra data at end of complex element
ORA-19753: error writing to change tracking file
ORA-16536: unknown object type
ORA-08114: can not alter a fake index
RMAN-06167: already connected
LSX-00234: invalid decimal "~S"
ORA-09820: Conversion of class string to numeric representation failed.
Oracle Errors 
