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-01613: instance string (thread string) only has string logs - at least 2 logs required to enable.

1 Answers  


ORA-30072: invalid time zone value

1 Answers  


ORA-14058: partition number string: INITRANS value must be less than MAXTRANS value

1 Answers  


ORA-13425: function not implemented

1 Answers  


PROT-00004: Failed to retrieve data from the cluster registry

1 Answers  






ORA-36258: (XSAGINFO00) When the AGGMAPINFO function is called, workspace object must be an AGGMAP.

1 Answers  


TNS-01202: Missing the dba group (string) specified by DBA_GROUP in SID_DESC

1 Answers  


NNO-00107: line string: ignoring stale checkpoint data

1 Answers  


ORA-28163: GRANT already specified

1 Answers  


PLS-00569: numeric overflow or underflow

1 Answers  


ORA-09370: Windows 3.1 Two-Task driver ORACLE task timed out

1 Answers  


ORA-03251: Cannot issue this command on SYSTEM tablespace

1 Answers  


Categories