Oracle Error PLS-00460: REPEATABLE subprogram ‘string’ has to be RNDS, WNDS, RNPS, and WNPS

Oracle Error Message

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

Reason for the Error

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

Solution

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