Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

NNO-00801: Error: OCI_SUCCESS_WITH_INFO: string

1 Answers  


PLS-00112: end-of-line in quoted identifier

1 Answers  


ORA-02260: table can have only one primary key

1 Answers  


IMP-00061: Warning: Object type "string"."string" already exists with a different identifier

1 Answers  


QSM-00756: the specified workload string is being used by one or more advisor tasks

1 Answers  


QSM-02086: mv uses the MIN or MAX aggregate functions

1 Answers  


ORA-01073: fatal connection error: unrecognized call type

1 Answers  


ORA-19622: archivelog thread string sequence string not restored due to string

1 Answers  


ORA-22883: object deletion failed

1 Answers  


QSM-02059: join may produce duplicate rows in mv

1 Answers  


NNL-00290: Cancelled cache flush

1 Answers  


ORA-19020: invalid dereference of XMLType columns

1 Answers  


Categories