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

ORA-01606: gc_files_to_locks not identical to that of another mounted instance

1 Answers  


ORA-25533: FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified

2 Answers  


ORA-30005: missing or invalid WAIT interval

1 Answers  


ORA-01901: ROLLBACK keyword expected

1 Answers  


ORA-12686: Invalid command specified for a service

1 Answers  






ORA-38723: Invalid SCN expression.

1 Answers  


LFI-00144: File [string][string] does not exist

1 Answers  


NZE-28811: invalid access descriptor

1 Answers  


ORA-01576: The instance string is not enabled

1 Answers  


ORA-22062: invalid input string [string]

1 Answers  


TNS-04233: Trace Assistant WARNING: Going beyond Packet length

1 Answers  


IMG-00607: unable to write to destination image

1 Answers  


Categories