This package will not compile because the body does not match the specification.
SQL>
SQL> CREATE OR REPLACE PACKAGE PackageA AS
2 FUNCTION FunctionA(p_Parameter1 IN NUMBER,
3 p_Parameter2 IN DATE)
4 RETURN VARCHAR2;
5 END PackageA;
6 /
Package created.
SQL> show errors
No errors.
SQL>
SQL> CREATE OR REPLACE PACKAGE BODY PackageA AS
2 FUNCTION FunctionA(p_Parameter1 IN CHAR,
3 p_Parameter2 IN DATE)
4 RETURN VARCHAR2;
5 END PackageA;
6 /
Warning: Package Body created with compilation errors.
SQL> show errors
Errors for PACKAGE BODY PACKAGEA:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2/12 PLS-00323: subprogram or cursor 'FUNCTIONA' is declared in a
package specification and must be defined in the package body
2/12 PLS-00328: A subprogram body must be defined for the forward
declaration of FUNCTIONA.
SQL>
SQL>
SQL>
Related examples in the same category