Typically a REFCURSOR is read by java and the set of data is processed within java. In our case we want to use that same REFCURSOR in another PL/SQL procedure.

How can we assign a REFCURSOR that resulted from package-1 to a cursor(expicit or implied) in a second package-2 ?

I hope i make sense.
thanks for your help.