Home -> Usenet -> comp.databases.oracle -> cursor in cursor

cursor in cursor

From: Ananth <apolepally_at_att.com>
Date: 1 Jun 2001 09:21:50 -0700
Message-ID: <a04d60e3.0106010821.14844b6d_at_posting.google.com> 






I am trying to impliment a cursor in cursor.
I have declared both of them together and fetching the second one for
every cursor row of the first one.


oracle is not able to recognize the second cursor.
Can anybody shed some light on this..an example would be great




DECLARE


CURSOR1;



CURSOR2


BEGIN


OPEN CURSOR1



LOOP (1)



   FETCH CURSOR1


         OPEN CURSOR2
         LOOP (2)
           FETCH CURSOR2


           --

           --

         END LOOP(2)
         CLOSE CURSOR2




END LOOP(1)



CLOSE CURSOR1


END;



Received on Fri Jun 01 2001 - 18:21:50 CEST












Original text of this message