Oracle Error PLS-00459: this feature is not allowed in REPEATABLE subprogram

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.