SQL & PL/SQL

declare
TYPE typ_name is ref cursor;
V_ref_cur typ_name;
CURSOR c1 is SELECT col1,col2 from table_name1;

BEGIN

for i in C1
Loop
Open v_ref_cur for

select * from table_name2;
end loop;

END;

Pls let me know if it is possible to open/use ref cursor inside a cursor for loop?


Thanks