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-31420: unable to submit the purge job

1 Answers  


ORA-30695: JDWP message format problem

1 Answers  


ORA-36184: (XSAGGR10) You do not have sufficient permissions for the variable workspace object.

1 Answers  


NZE-28758: memory release failure

1 Answers  


NNL-00517: Insert-replaces a data item under an existing name

1 Answers  






ORA-28278: No domain policy registered for password based GLOBAL users.

1 Answers  


IMG-00554: extra value in rotate operation

1 Answers  


ORA-23401: materialized view "string"."string" does not exist

1 Answers  


ORA-02359: internal error setting attribute string

1 Answers  


ORA-02177: Missing required group number

1 Answers  


ORA-28279: Error reading ldap_directory_access init parameter.

1 Answers  


ORA-16545: unable to get response

1 Answers  


Categories