Re: Can you open a cursor within a cursor?

From: Dave Morse <dmorse_at_nospam.cinergy.com>
Date: Wed, 29 Apr 1998 09:29:19 -0500
Message-ID: <6i7df7$h1j$1@news.iquest.net>

I'm new to PL/SQL and am making a change for a production procedure.

Sorry I asked!

Dave Morse wrote in message <6i5ek0$mjk$1_at_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 Wed Apr 29 1998 - 09:29:19 CDT