Ref Cursors

[sandya]

Hi,

I have a few doubts in Pl/SQL.

1) Can a refer to a REF CURSOR in a CURSOR FOR LOOP?

for eg :

for i in
loop
...

end loop;

Is this possible ??

2) In a block like
declare
x %rowtype;
begin

end;
Can be passed as a parameter to this block ?

Pls clarify !!!

Rgds,
Sandya

[nishant]

hi,
=======
Declare
TYPE EmpCurTyp IS REF CURSOR;
emp_cv EmpCurTyp;
begin
OPEN emp_cv FOR 'select
empno,ename from emp';
loop
fetch emp_cv into empno,ename;
exit when emp_cv%notfound;
---
---
---
end loop;
close emp_cv;
end;
=======
peace
Nishant.