Re: Can you open a cursor within a cursor?

From: <joseph_testa_at_aep.com>
Date: Wed, 29 Apr 1998 07:25:55 -0600
Message-ID: <6i768j$77a$1@nnrp1.dejanews.com>

Have you tried it?, i find the best way to learn is to experiment. the answer is yes you can, what u r doing is opening another cursor within the loop.

joe
http://www.oracle-dba.com

In article <6i5ek0$mjk$1_at_news.iquest.net>, "Dave Morse" <dmorse_at_nospam.cinergy.com> wrote:
>
> 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.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Apr 29 1998 - 08:25:55 CDT