In this post, you’ll learn more about the Oracle ErrorPLS-00323: subprogram or cursor ‘string’ is declared in a package specification and must be defined in the package body with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00323: subprogram or cursor ‘string’ is declared in a package specification and must be defined in the package body
Reason for the Error PLS-00323: subprogram or cursor ‘string’ is declared in a package specification and must be defined in the package body
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.
How to fix the Error PLS-00323: subprogram or cursor ‘string’ is declared in a package specification and must be defined in the package body ?
You can fix this error in Oracle by following the below steps
Check the spelling of the subprogram name. If necessary, add the missing subprogram body to the package body.