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

LRM-00113: error when processing file 'string'

1 Answers  


ORA-12642: No session key

1 Answers  


QSM-01026: query rewrite is disabled for, string

1 Answers  


LPX-00259: invalid notation declaration

1 Answers  


RMAN-06033: channel string not allocated

1 Answers  






ORA-12086: table "string"."string" is not an object table

1 Answers  


QSM-02040: top level query contains GSets and the key is too long for rewrite

1 Answers  


ORA-38451: index is in an inconsistent state

1 Answers  


ORA-01040: invalid character in password; logon denied

1 Answers  


ORA-13801: invalid value for SQLTUNE_CATEGORY parameter

1 Answers  


PCC-00061: Error at line number, column number. PLS-number: string

1 Answers  


LFI-00144: File [string][string] does not exist

1 Answers  


Categories