PLS-00539: subprogram 'string' is declared in an object type
body and must be defined in the object type specification



PLS-00539: subprogram 'string' is declared in an object type body and must be defined in ..

Answer / guest

Cause: The specified subprogram is declared in an object
type's body, but is not defined in the object type's
specification. Notice cursor bodies can exist without a
specification.

Action: Define the subprogram in the object type's
specification, or remove the declaration from the body.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NID-00397: Changing database name from string to string

1 Answers  


NNO-00318: overriding next statistic counter reset, resetting in number seconds

1 Answers  


ORA-23332: group string is in use; cannot drop

1 Answers  


TNS-12166: TNS:Client can not connect to HO agent.

1 Answers  


ORA-14174: only a <parallel clause> may follow COALESCE PARTITION|SUBPARTITION

1 Answers  


ORA-30106: reserved for future use

1 Answers  


ORA-32845: Messaging Gateway agent is already running

1 Answers  


ORA-16112: log mining and apply stopping

1 Answers  


DRG-11806: Non-authoritative Information

1 Answers  


AMD-00111: PROCEDURE string, invalid directory: "string"

1 Answers  


ORA-16235: DDL skipped because import has occurred

1 Answers  


DRG-50921: EQUIV operand not a word or another EQUIV expression

1 Answers  


Categories