Re: PL/SQL nested cursors and loops

Hi,

thanks for your reply but it was just quick pcode What Im looking for is a method to remove the nested inner cursor opening and closing.
I can feed the results from the first cursor into a plsql table but then hiw can I open a second curosor to process the table?

thanks
Kelvin

cadkim_at_aol.com (Cadkim) wrote:

>Kelvin
 

>open c1
>loop
>fetch c1 into a;
>exit when notfound
> open c2(a)
> loop
> fetch c2 into x
> exit when notfound
> end loop
> close c2
>end loop c1
>-------------------
>
Received on Mon Sep 16 1996 - 00:00:00 CEST