PLS-00538: subprogram or cursor 'string' is declared in an
object type specification and must be defined in the object
type body



PLS-00538: subprogram or cursor 'string' is declared in an object type specification and ..

Answer / guest

Cause: The specified subprogram is declared in an object
type's specification, but is not defined in the object type
body.

Action: Define the subprogram in the object type body, or
remove the declaration from the specification.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02373: Error parsing insert statement for table string.

1 Answers  


ORA-15177: cannot operate on system aliases

1 Answers  


DRG-51301: error releasing dml Queue lock

1 Answers  


ORA-01483: invalid length for DATE or NUMBER bind variable

1 Answers  


ORA-02024: database link not found

1 Answers  


TNS-02509: Authentication: invalid process state

1 Answers  


ORA-32801: invalid value string for string

1 Answers  


ORA-29343: user string (mapped from user string) does not exist in the database

1 Answers  


ORA-07327: smpdal: attempt to destroy pga when it was not mapped.

1 Answers  


ORA-14629: cannot drop the only subpartition of a partition

1 Answers  


ORA-09957: Unable to send termination request to IMON

1 Answers  


ORA-32812: subscriber string does not exist

1 Answers  


Categories