Re: Cursors

Or maybe try this

cursor one is
select a, b
  from tab_one;

cursor two(var_name VAR_TYP) is
 select c, d

    from tab_two
  where c=var_name;

begin
  for rec1 in one loop
    ...
    for rec2 in who(rec1.a) loop
      ...
    end loop;
  end loop;
end;

????????

On Tue, 21 Dec 1999, Stéphane D'Hoedt wrote:
>Hi,
>
>I made cursors in my procedure. But I would like to know if I can call a
>field of a cursor in another cursor.
>I hope there is someone who can help me.
>
>Thanks,
>Stéphane D'Hoedt
Received on Tue Dec 28 1999 - 15:35:30 CST