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