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-01303: subordinate process error: number. Check alert and trace logs

1 Answers  


NNO-00311: invalid listen address list

1 Answers  


NNL-00417: Distinguished Name: string

1 Answers  


LPX-00100: root element "~1S" does not match DTD root "~2s"

1 Answers  


ORA-33302: (DBVALID01) SEVERE ERROR: Record number multiply used.

1 Answers  


TNS-00257: Number of Successful Requests : number

1 Answers  


ORA-16719: unable to query V$ARCHIVE_DEST fixed view

1 Answers  


ORA-14118: CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION

1 Answers  


QSM-02050: subquery using the ALL clause in mv

1 Answers  


ORA-16525: the Data Guard broker is not yet available

2 Answers  


ORA-24160: name string already exists in the name value pair list

1 Answers  


ORA-26013: List allocated may not be big enough

1 Answers  


Categories