Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-08277: Cannot set environment variable

1 Answers  


PCC-02330: expecting an expression of integer type

1 Answers  


LPX-00314: an internal failure occurred

1 Answers  


ORA-29502: NAMED keyword required in CREATE JAVA RESOURCE

1 Answers  


NCR-00001: NCR: Could not allocate memory

1 Answers  






NNC-00431: NS address does not match any of the current addresses

1 Answers  


ORA-12465: Not authorized for read or write on specified groups or compartments

1 Answers  


ORA-01101: database being created currently mounted by some other instance

1 Answers  


ORA-01413: illegal value in packed decimal number buffer

1 Answers  


PLS-00718: type of attribute 'string' does not allow modifications to the attribute

1 Answers  


ORA-16058: standby database instance is not mounted

1 Answers  


ORA-36716: (XSMXALLOC04) You can only use the ACROSS phrase when allocation BASIS workspace object is a FORMULA.

1 Answers  






Categories