EXAMPLE ON PROCEDURE OVERLOADING

Q)CREATE A PACKAGE TO DISPLAY THE EMPLOYEE DETAILS WHEN EMPLOYEE NUMBER PASSED AS IN PARAMETER & DISPLAY THE DEPARTMENT DETAILS WHEN DEPARTMENT NAME PASSED AS IN PARAMETER?
A)Create or Replace Package mypack
     IS
     Procedure p(p_empno in emp.empno%type, a  OUT sys_refcursor);
     Procedure p(p_dname  in dept.dname%type,b  OUT sys_refcursor);
     End;
   
     Create or Replace Package Body mypack
     IS
     Procedure p(p_empno in emp.empno%type, a  OUT sys_refcursor);
     IS
     Begin
     Open  a  for  select * from emp where  empno=p_empno;
     End p;
     Procedure p(p_dname  in dept.dname%type,b  OUT sys_refcursor);
     IS
     Begin
     Open  b  for  select * from dept where dname=p_dname;
     End p;
     End;