How to fix the Oracle error PLS-00460: REPEATABLE subprogram ‘string’ has to be RNDS, WNDS, RNPS, and WNPS?

In this post, you’ll learn more about the Oracle ErrorPLS-00460: REPEATABLE subprogram ‘string’ has to be RNDS, WNDS, RNPS, and WNPS with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error PLS-00460: REPEATABLE subprogram ‘string’ has to be RNDS, WNDS, RNPS, and WNPS ?

You can fix this error in Oracle by following the below steps

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