Re: Dynimic Cursors

From: Patrick Hamou <patrick_hamou_at_hotmail.com>
Date: Sat, 23 Oct 1999 04:14:46 GMT
Message-ID: <WCaQ3.22683$up3.30684@news21.bellglobal.com>

no,
this type of "dynamic" cusror isn'y possible, but why don't you simply use the DBMS_SQL
package ? ...

If you need more information on the DBMS_SQL package I would suggest you to read
the book PL/SQL Programming from Osborne (Oracle Press) whitch contains a full chapter on
how to use the DBMS_SQL package ...

regards,

Patrick Hamou,
Oracle DBA
patrickhamou_at_hotmail.clom

NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message news:3810c4f1.347913234_at_news.earthlink.net...
> Is something like that possible?
> Is there are a way to use DBMS_SQL with cursors?
>
> Thanx
>
> CREATE OR REPLACE PROCEDURE HUJ(p_field IN varchar2)
> IS
> CURSOR c_top is
> SELECT nvl(p_field,0) from manager
> ORDER BY nvl(p_field,0) DESC;
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
Received on Fri Oct 22 1999 - 23:14:46 CDT