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-00460: REPEATABLE subprogram 'string' has to be RNDS,
WNDS, RNPS, and WNPS



PLS-00460: REPEATABLE subprogram 'string' has to be RNDS, WNDS, RNPS, and WNPS..

Answer / guest

Cause: Repeatable subprogram can neither read database state
(RNDS), write database state (WNDS), read package state
(RNPS), nor write package state (WNPS).

Action: make the subprogram to be RNDS, WNDS, RNPS, and WNPS
or delete REPEATABLE

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-33036: (XSAGDNGL17) ARGS option workspace object must be a TEXT variable.

1 Answers  


ORA-25534: _MEAN_TIME_TO_CLUSTER_AVAILABILITY is specified

1 Answers  


ORA-37076: (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT and NTEXT.

1 Answers  


ORA-02472: PL/SQL functions not allowed in hash expressions

1 Answers  


O2F-00315: An attribute of a type is listed twice in a type specification

1 Answers  


ORA-16700: The standby database has diverged from the primary database.

1 Answers  


ORA-25958: join index where clause predicate may only contain column references

1 Answers  


CLSR-00517: Failed to register a service name

1 Answers  


DRG-10303: could not queue given commands to be processed

1 Answers  


ORA-14053: illegal attempt to modify string in string statement

1 Answers  


ORA-02276: default value type incompatible with column type

1 Answers  


ORA-14298: LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 Answers  


Categories