i want to out the result as a ref cursor.can i include cursor in that ref cursor like the following
procedure get_data(idea_cur out GenericCursorType)
Is
Begin
open idea_cur for
select t.deptid,t.deptname,cursor(select a.id,a.namefrom TABLE(t.emp) a)
from dept t;
End ;
procedure get_data(idea_cur out GenericCursorType)
Is
Begin
open idea_cur for
select t.deptid,t.deptname,cursor(select a.id,a.namefrom TABLE(t.emp) a)
from dept t;
End ;