Unit Test for out cursor parameter
851927Aug 29 2011 — edited Nov 21 2011Hi all!
i'm trying to build a test for a simple procedure in a package that has an out cursor parameter. but i can't understand how to build a test for that
create or replace
PACKAGE BODY PA_EMP AS
PROCEDURE GETEMPLOYEES (IN_HIREDATE IN DATE
,OUT_CURSOR OUT sys_refcursor) AS
BEGIN
OPEN OUT_CURSOR FOR
SELECT E.EMPNO, E.ENAME
FROM SCOTT.EMP E
--WHERE E.HIREDATE < IN_HIREDATE
;
so i tried to do like this
http://imageshack.us/photo/my-images/824/snap20110829193726001.png/
define a dynamic query, but it doesn#t work. Can't someone bring me on the right way?
Is there a documantation how to make a test for cursor, collection?
Thx
END PA_EMP;