Re: Can you open a cursor within a cursor?

From: Frank <Oaplont_at_work.no>
Date: Wed, 29 Apr 1998 05:57:50 GMT
Message-ID: <6i6fg0$62d$1@hdxf08.telecom.ptt.nl>

This is more or less standard programming, so I hope it still works. I use it all the time !
Why don't you just try it ?

Frank

"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.
Received on Wed Apr 29 1998 - 00:57:50 CDT