This is the script Why am in unable to create a package body ??
CREATE or replace PACKAGE ko_mailing_pkg AS
PROCEDURE mail(p_from varchar2,p_to varchar2,p_sub varchar2,p_body varchar2) ;end ko_mailing_pkg;
/
CREATE OR REPLACE PACKAGE BODY ko_mailing_pkg AS
PROCEDURE mail(p_from varchar2,p_to varchar2,p_sub varchar2,p_body varchar) IS
BEGIN
null;
END mail;
end ko_mailing_pkg;
but this throws error we can see the mail procedure clearly mentioned in package body
The output .. package created but not package body
SQL> start pb
Package created.
11 /
Warning: Package Body created with compilation errors.
SQL> show error
Errors for PACKAGE BODY KO_MAILING_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
3/12 PLS-00323: subprogram or cursor 'MAIL' is declared in a package
specification and must be defined in the package body