Re: Nested Cursor

From: Ñèëàíòüåâ À.Â. <silantiev_at_bashkortostan.ru>
Date: Tue, 3 Jul 2001 11:02:23 +0600
Message-ID: <9hrjjj$ise$1@poikc.bashnet.ru>

Bala <kmbase_at_usa.net> ñîîáùèë â íîâîñòÿõ ñëåäóþùåå:7d52c6a5.0106280138.d4f83a5_at_posting.google.com...
> Hi,
> Is it possible to have a nested cursor. That is
> for instance, while declaring the first cursor i
> will issue a select statement. And while looping
> this cursor and based on the value of some columns
> returned by this cursor is it possible to built
> another cursor.If so,will u give me sample code.
> Thanks in advance
>
> Regards,
> Bala

You can to use dynamic sql supported by DBMS_SQL package.

Alexander V. Silantiev Received on Tue Jul 03 2001 - 00:02:23 CDT