Get a ref cursor from within another procedure

[llmclaughlin]

I have procedure which returns a ref cursor like.
PROCEDURE DEST_WORK_LIST_DATE (outCURSOR OUT OUTPUTCURSOR)
IS
BEGIN
OPEN outCURSOR FOR
SELECT u_worklist_date, u_worklist_increment
FROM u_worklist_user
WHERE TRUNC (u_worklist_date) = TRUNC (SYSDATE)
AND u_type = 'DESTINATIONALIQUOT';
END DEST_WORK_LIST_DATE;

Is there a way I can call this from another procedure to return the data to it or maybe should say get this cursor into another cursor in another procedure.



Louie

 

[SantaMufasa]

What results did you receive when you tried it?

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.