Oracle Error PLS-00461: mismatch REPEATABLE information between specification and body of ‘string’

Oracle Error Message

PLS-00461: mismatch REPEATABLE information between specification and body of ‘string’

Reason for the Error

REPEATABLE is declared at the subprogram’s specification, but not at its body, or vice versa.

Solution

make sure both specification and body are declared as REPEATABLE