Live ORACLE

CREATE PACKAGE emp_bonus
AS
 PROCEDURE calc_bonus(date_hired  employees.hire_date%TYPE);
END emp_bonus;
/

CREATE PACKAGE BODY emp_bonus
AS
 -- the following parameter declaration raises an exception
 -- because 'DATE' does not match employees.hire_date%TYPE
 -- PROCEDURE calc_bonus (date_hired DATE) IS
 -- the following is correct because there is an exact match
 PROCEDURE Calc_bonus
      (date_hired  employees.hire_date%TYPE)
 IS
 BEGIN
   dbms_output.Put_line('Employees hired on '
                        ||date_hired
                        ||' get bonus.');
 END;
END emp_bonus;
/  

Matching Package Specifications and Bodies