-
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
-
Hi
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.