PLS-00461: mismatch REPEATABLE information between
specification and body of 'string'



PLS-00461: mismatch REPEATABLE information between specification and body of 'string'..

Answer / guest

Cause: REPEATABLE is declared at the subprogram's
specification, but not at its body, or vice versa.

Action: make sure both specification and body are declared
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

ORA-15125: ASM file name 'string' contains an invalid template name

1 Answers  


ORA-07271: spwat: invalid oracle process number.

1 Answers  


DRG-11718: multiple Preferred Terms for term string

1 Answers  


ORA-32626: illegal bounds or increment in MODEL FOR loop

1 Answers  


PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

1 Answers  






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

1 Answers  


ORA-40209: setting % is invalid for % function

1 Answers  


RMAN-06048: duplicate controlfile specified for restoration from copy

1 Answers  


ORA-19706: invalid SCN

1 Answers  


SQL*Loader-00522: lfiopn failed for file (string)

1 Answers  


ORA-29327: unsupported client compatibility mode used when talking to the server

1 Answers  


ORA-25247: %s is not a recipient of specified message

1 Answers  


Categories