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.