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

DRG-50802: failed to bind input

1 Answers  


ORA-07639: smscre: SGA pad area not large enough (string bytes required)

1 Answers  


ORA-19031: XML element or attribute string does not match any in type string.string

1 Answers  


ORA-12657: No algorithms installed

1 Answers  


NID-00430: Database is ready to be open or shut down.

1 Answers  


ORA-02253: constraint specification not allowed here

3 Answers  


NZE-28890: Entrust Login Failed

0 Answers  


ORA-14404: partitioned table contains partitions in a different tablespace

1 Answers  


ORA-26667: invalid STREAMS parameter string

1 Answers  


ORA-00270: error creating archive log string

1 Answers  


NPL-00303: uninitialized ASN.1 class attribute

1 Answers  


NNL-00233: Auto-refresh failure-retry interval is now string

1 Answers  


Categories