Oracle Error Message
PLS-00459: this feature is not allowed in REPEATABLE subprogram
Reason for the Error
Having one of the followings feature in the REPEATABLE subprogram: dynamic SQL statements or autonomous transaction.
Solution
delete the statements or delete REPEATABLE.