PLS-00452: Subprogram 'string' violates its associated pragma



PLS-00452: Subprogram 'string' violates its associated pragma..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-06742: TLI Driver: cannot alloc t_bind

1 Answers  


ORA-13799: threshold not found

1 Answers  


PLS-00221: 'string' is not a procedure or is undefined

1 Answers  


LCD-00208: unexpected keyword in value list [string]

1 Answers  


PCC-01003: Invalid continuation at line number in file string

1 Answers  


ORA-24406: API mode switch is disallowed when a call is in progress.

1 Answers  


IMG-00520: invalid value for numberOfBands

1 Answers  


ORA-28263: Insufficient memory in global context pool

1 Answers  


NNL-00518: Shows or sets the maximum number of times a server can reforward a request

1 Answers  


ORA-19599: block number string is corrupt in string string

1 Answers  


NID-00505: REVERT Revert failed change NO

1 Answers  


O2I-00110: Internal error in OTT component O2I

1 Answers  


Categories