CREATE OR REPLACE PACKAGE foo AS

  PROCEDURE getDept(dept_id IN NUMBER, dept_name OUT VARCHAR2);
  
END foo;

CREATE OR REPLACE PACKAGE BODY foo AS

    PROCEDURE getDept(dept_id IN NUMBER, dept_name OUT VARCHAR2) IS
    BEGIN
    
         SELECT dept INTO getDept.dept_name
         FROM Dept
         WHERE idDept = getDept.dept_id;
    
    END getDept;

END foo;