PLS-00462: nested subprogram 'string' has to be REPEATABLE



PLS-00462: nested subprogram 'string' has to be REPEATABLE..

Answer / guest

Cause: the nested subprogram of a REPEATABLE subprogram is
not declared as REPEATABLE. If a subprogram is REPEATABLE,
all of its nested subprograms has to be declared as REPEATABLE.

Action: declared the nested subprogram as REPEATABLE

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11211: charset column must be a char, varchar, or varchar2 type

1 Answers  


ORA-37013: (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.

1 Answers  


ORA-39014: One or more workers have prematurely exited.

1 Answers  


ORA-30766: cannot modify scope for a REF column with a REFERENCES constraint

1 Answers  


ORA-08445: syntax error in SIGN clause in mask options

1 Answers  






RMAN-06007: target database not mounted and db_name not set in init.ora

1 Answers  


RMAN-06709: No scripts in recovery catalog

1 Answers  


IMG-00705: unsupported or corrupted input format

1 Answers  


ORA-16526: unable to allocate task element

1 Answers  


ORA-24437: OCIStmtExecute called before OCIStmtPrepare2.

1 Answers  


SQL*Loader-00475: field for dynamic file name is string in table string

1 Answers  


SQL*Loader-00941: Error during describe of table string

1 Answers  


Categories