Oracle Error PLS-00462: nested subprogram ‘string’ has to be REPEATABLE

Oracle Error Message

PLS-00462: nested subprogram ‘string’ has to be REPEATABLE

Reason for the Error

the nested subprogram of a REPEATABLE subprogram is not declared as REPEATABLE. If a subprogram is REPEATABLE, all of its nested subprograms has to be declared as REPEATABLE.

Solution

declared the nested subprogram as REPEATABLE