hi gurus,
i am using oracle 8i and did some dynamic ref cursor stuff...i ll pass the tablename and the where clause to the function which will do the necessary and return the refcursor.
ex :
====
v_sqlstr:=v_sqlstr || ' and rownum<=' || istrow;
OPEN v_curwishlist FOR v_sqlstr;
..
..
return v_curwishlist;
now for some reasons we wanted to reuse the same techn. in oracle 7.3...so i wanted the help of u gurus of how to implement the dynamic ref cursor in 7.3..any alternate solutions would also be of great help for me.
thankx
Vijays
