Re: Cursors
From: WaltX <waltx_at_dnet.it>
Date: Tue, 28 Dec 1999 22:35:30 +0100
Message-ID: <946417148.1072387681_at_news.interbusiness.it>
Date: Tue, 28 Dec 1999 22:35:30 +0100
Message-ID: <946417148.1072387681_at_news.interbusiness.it>
Or maybe try this
cursor one is
select a, b
[Quoted] 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 - 22:35:30 CET