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



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

Answer / guest

Cause: Having one of the followings feature in the
REPEATABLE subprogram: dynamic SQL statements or autonomous
transaction.

Action: delete the statements or delete REPEATABLE.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25217: enqueue failed, visibility must be IMMEDIATE for queue string.string

1 Answers  


SQL*Loader-00553: file not found

1 Answers  


NNO-00852: failed to get LDAP entry: error = number

1 Answers  


SQL*Loader-00919: Error during upi fetch: [number]

1 Answers  


ORA-09978: skxfqhdel: Error Disconnecting from another endpoint.

1 Answers  






ORA-19006: XMLType TYPE storage option not appropriate for storage type

1 Answers  


ORA-32611: incorrect use of MODEL CV operator

1 Answers  


QSM-02161: see the reason why REFRESH_FAST_AFTER_ONETAB_DML is disabled

1 Answers  


ORA-26681: command type not supported

1 Answers  


ORA-14618: cannot drop the last value of subpartition

1 Answers  


ORA-29387: no top-plans found in the pending area

1 Answers  


ORA-07500: scglaa: $cantim unexpected return

1 Answers  


Categories