CREATE OR REPLACE PACKAGE foo AS

  -- PROCEDURE getDept(dept_id IN NUMBER, dept_name OUT VARCHAR2);
  
  /*
    This is a package wide variable type that can hold the contents
    of the entire department table
  */
  TYPE deptTable IS TABLE OF dept%rowtype INDEX BY BINARY_INTEGER;

  PROCEDURE getAllDept(dept OUT deptTable);
  
END foo;

CREATE OR REPLACE PACKAGE BODY foo AS

    PROCEDURE getAllDept(dept OUT deptTable) IS
        CURSOR cursDept IS
            SELECT * FROM dept;
            
        i NUMBER := 0;
    BEGIN
         
        OPEN cursDept;
        LOOP
            FETCH cursDept INTO getAllDept.dept(i); /* put all of the dept table's records in the variable */
            i := i + 1;
            EXIT WHEN cursDept%NOTFOUND;
        END LOOP;
        
        CLOSE cursDept;
    END getAllDept;

END foo;