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

ORA-33080: (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.

1 Answers  


DRG-11215: index owner does not have access to filter stored procedure: string

1 Answers  


ORA-31107: Action failed as resource "string" is locked by name lock

1 Answers  


ORA-00291: numeric value required for PARALLEL option

1 Answers  


ORA-14293: Number of partitioning columns does not match number of subpartitioning columns

1 Answers  


ORA-27477: "string.string" already exists

1 Answers  


LCD-00217: failure while processing file parameter [string]

1 Answers  


ORA-31667: parameter name can not be defaulted

1 Answers  


ORA-07407: slbtpd: invalid exponent.

1 Answers  


PCC-02395: Using arrays of structs requires that the struct be named

1 Answers  


EXP-00022: must be SYS or SYSTEM to do incremental export

1 Answers  


ORA-39020: invalid mode type string

1 Answers  


Categories