PLS-00323: in spec but not in body

Errors for PACKAGE BODY SECURITY_MONITOR:
LINE/COL ERROR——– —————————————————————–6/11 PLS-00323: subprogram or cursor ‘DBG’ is declared in a package specification and must be defined in the package body

Caused by having:

procedure dbg (p_text varchar2) is ….in the body, and
procedure dbg (p_text varchar2) ….in the spec

Advertisements