CREATE OR REPLACE PACKAGE foo AS

  TYPE deptCurs IS REF CURSOR; 
  
  FUNCTION getAllDept RETURN foo.deptCurs;
END foo;