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-14456: cannot rebuild index on a temporary table

1 Answers  


LSX-00172: "~S" is not a valid restriction of "~S"

1 Answers  


RMAN-01008: the bad identifier was: string

1 Answers  


ORA-36872: (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.

1 Answers  


RMAN-06418: proxy incremental backups with level > 0 not supported

1 Answers  






ORA-24760: invalid isolation level flags

1 Answers  


ORA-26660: Invalid action context value for string

1 Answers  


TNS-12551: TNS:missing keyword

1 Answers  


ORA-16767: Logical apply service unexpectedly online

1 Answers  


ORA-22371: Table contains data of type string.string, version string, which does not exist

1 Answers  


ORA-19757: could not resize change tracking file to string blocks

1 Answers  


PLS-01506: CREATE INDEX is non-ANSI

1 Answers  


Categories