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

PLS-00352: Unable to access another database 'string'

1 Answers  


ORA-16553: the Data Guard broker process (DMON) failed to shutdown

1 Answers  


ORA-36812: (XSTBLFUNC06) Invalid Syntax at '?'.

1 Answers  


DRG-12012: Proxy authentication failed - retry?

1 Answers  


ORA-07223: slspool: fork error, unable to spawn spool process.

1 Answers  






ORA-02080: database link is in use

1 Answers  


ORA-06119: NETTCP: spurious client request

1 Answers  


ORA-02148: EXCLUSIVE specified multiple times

1 Answers  


NZE-28781: No data for the access method is specified in the parameter.

1 Answers  


NNO-00107: line string: ignoring stale checkpoint data

1 Answers  


ORA-30392: the checksum analysis for the rewrite equivalence failed

1 Answers  


ORA-14252: invalid ALTER TABLE MODIFY PARTITION option for a Hash partition

1 Answers  


Categories