I have a storedProcedure defined as following :
PROCEDURE GetAccessRights(AAccessRights OUT CURSOR_TYPE) AS
BEGIN
  OPEN AAccessRights FOR
    SELECT  AccessRightID, AccessUnitID, AccessObjectID, GrantRights, DenyRights
    FROM    AccessRights;
END;
Then I try to call it from SQL Developer:
DECLARE
  QPZ    DDKPROD.DDK.CURSOR_TYPE;
  ACCESSRIGHTID   AccessRights.ACCESSRIGHTID%TYPE;
  ACCESSUNITID    AccessRights.ACCESSUNITID%TYPE;
  ACCESSOBJECTID  AccessRights.ACCESSOBJECTID%TYPE;
  GRANTRIGHTS     AccessRights.GRANTRIGHTS%TYPE;
  DENYRIGHTS      AccessRights.DENYRIGHTS%TYPE;
BEGIN
  DDK.GETACCESSRIGHTS(qpz);
  LOOP
    FETCH 
      QPZ INTO ACCESSRIGHTID, ACCESSUNITID, ACCESSOBJECTID, GRANTRIGHTS, DENYRIGHTS;
    EXIT 
      WHEN QPZ%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE(ACCESSRIGHTID || '     ' || ACCESSUNITID);
  END LOOP;  
  CLOSE QPZ;
END;
My problem is the only output I get is the following message:
anonymous block completed
There are 80 rows in my AccessRights. why doesn't i get them listed in my loop
