PL/SQL nested cursors and loops

Hi all,

Can i remove this nested cursor problem

Im feeding the result from c1 into c2.
For every loop of c1, the cursor c2 opens fetches and closes

Can I feed c1 into something then close c1 and open c2 to process the values.

cursor c1 is select a from t1;
cursor c2(a) is select a,b from t2 where col1 = (a)

open c1
loop
fetch c1 into a;
exit when notfound

	open c2(a)
	loop
	fetch c2 into x
	exit when notfound
	end loop
	close c2

thanks
Kelvin Received on Thu Sep 05 1996 - 00:00:00 CEST