Re: PL/SQL nested cursors and loops

From: Cadkim <cadkim_at_aol.com>
Date: 1996/09/14
Message-ID: <51dhcv$cra_at_newsbf02.news.aol.com>#1/1

Kelvin

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

end loop c1

---

if c2%ISOPEN then close c2;
------ If the fetch of c2 results in a notfound condition c2 is never closed. By checking the state of c2 with the above statement this condition will be corrected.
close c1

D. Kim Hughes Managing Consultant
Deloitte & Touche Consulting Group
DRT Systems
1225 N. Loop West
Suite 825
Houston, TX 77008
(713)868-5537
Kim_Hughes_at_notes.drthou.com Received on Sat Sep 14 1996 - 00:00:00 CEST