Oracle Error PLS-00323: subprogram or cursor ‘string’ is declared in a package specification and must be defined in the package body

Oracle Error Message

PLS-00323: subprogram or cursor ‘string’ is declared in a package specification and must be defined in the package body

Reason for the Error

A subprogram specification was placed in a package specification, but the corresponding subprogram body was not placed in the package body. The package body implements the package specification. So, the package body must contain the definition of every subprogram declared in the package specification.

Solution

Check the spelling of the subprogram name. If necessary, add the missing subprogram body to the package body.