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-25215: user_data type and queue type do not match

1 Answers   WalMart,


ORA-02256: number of referencing columns must match referenced columns

1 Answers  


ORA-00339: archived log does not contain any redo

1 Answers  


ORA-02047: cannot join the distributed transaction in progress

1 Answers  


ORA-26097: unsupported conversion for column string (from type number to type number)

1 Answers  


ORA-40215: model string is incompatible with current operation

1 Answers  


O2F-00333: An unexpected token appeared where a keyword was expected in the INTYPE file

1 Answers  


PCB-00701: MAX OCCURRANCES must be between 1 and 65535

1 Answers  


PCB-00204: Group items cannot be used except in INTO or VALUES clause

1 Answers  


NZE-28846: No private key

1 Answers  


NNL-01069: Log file name: string

1 Answers  


ORA-03222: average row size and row count must be greater than zero

1 Answers  


Categories