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

RMAN-05010: target database must be opened in READ WRITE mode for TSPITR

1 Answers  


ORA-02028: fetching an exact number of rows is not supported by the server

1 Answers  


ORA-31054: The string operator cannot have an ancillary operator

1 Answers  


ORA-40001: value for string must be greater than zero

1 Answers  


DRG-11603: URL store: payment required to access string

1 Answers  






ORA-16156: LGWR archive log dependency not allowed if database is standby protected

1 Answers  


NNO-00109: line string: invalid data type name "string", data ignored

1 Answers  


QSM-02114: no GROUP BY clause, no aggregates and not >= 9.0 compatibility

1 Answers  


ORA-01095: DML statement processed zero rows

1 Answers  


SQL*Loader-00476: count of elements for collection is not set or null, 0 will be used

1 Answers  


TNS-00132: COST value must be an integer greater than 0

1 Answers  


ORA-30150: Invalid argument passed to OCIFile function

1 Answers  


Categories