Can you open a cursor within a cursor?

From: Dave Morse <dmorse_at_nospam.cinergy.com>
Date: Tue, 28 Apr 1998 15:36:55 -0500
Message-ID: <6i5ek0$mjk$1@news.iquest.net>

Is it possible to open a cursor within another cursor (as follows):

---

cursor c_cursor1 is
 SELECT ... cursor c_cursor2 is
 SELECT ... OPEN c_cursor1;

   Fetch c_cursor1 INTO ...

   IF .. = .. THEN

       OPEN c_cursor2
          Fetch c_cursor2 INTO ...

   CLOSE c_cursor2;
 ELSE
 ...
 END IF;
CLOSE c_cursor1;

---

To respond, please take out "nospam" in e-mail address

Dave Morse
dmorse_at_iquest.net
Consultant - InfoTech Consulting, Inc. Received on Tue Apr 28 1998 - 15:36:55 CDT