method-r.com

I would greatly appreciate any help with the following:

CURSOR get_emp IS SELECT * FROM EMPLOYEE;
TYPE type_rc is REF CURSOR;
out_rc type_rc;

I want to RETURN out_rc in my function. How do I get the results of the explicit cursor get_emp into the cursor variable out_rc?
I don't thonk a simple assignment will work as in
out_rc := get_emp beacuse one is a ref cursor and the other a cursor
I know I could create a nested table say nest_tab with a CREATE statement outside of this function, put the rows from the get_emp rows into the nested table and then do a OPEN out_rc FOR SELECT FROM TABLE(nest_tab)

But is there a more simpler way to do this and avoid the movement of the rows via the nested table? Also this a high concurrency application and even this extra movement of data via the nested table will cost us dearly.

Thanks in anticipation.