Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00452: Subprogram 'string' violates its associated pragma
- 1 Answers
- 3677 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 |
RMAN-06488: restore from autobackup does not allow any other modifiers
RMAN-06580: the string option cannot be used with AS COPY
NNL-00545: Displays query request statistics
ORA-24422: error occurred while trying to destroy the Session Pool
DRG-10310: servers were shutdown before processing request
ORA-08113: composite partition index may not be compressed
ORA-24329: invalid character set identifier
RMAN-06016: duplicate backup operand specified: string
NNL-00811: Fastest query processing time: string
ORA-12611: TNS:operation is not portable
ORA-38441: System could not derive the list of STORED and INDEXED attributes.
ORA-06757: TLI Driver: server got bad command
Oracle Errors 
