CREATE PACKAGE cv_datasource IS
TYPE emprec is RECORD (empno emp.empno%TYPE,ename emp.ename%TYPE);--,job emp.job%TYPE,mgr emp.mgr%TYPE,sal emp.sal%TYPE,comm emp.comm%TYPE,deptno emp.deptno%TYPE);
TYPE empcur is REF CURSOR RETURN emprec;
PROCEDURE empquery(resultset IN OUT empcur);--,p_deptno IN NUMBER);
END;
/
CREATE PACKAGE BODY cv_datasource IS PROCEDURE empquery(resultset IN OUT empcur)--
is--,p_deptno IN NUMBER) IS
BEGIN
OPEN resultset FOR
	SELECT empno, ename--, job, mgr, sal, comm, deptno
	FROM emp
	WHERE deptno = 20
	ORDER BY empno;
	END;
END;