Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Dynimic Cursors

Dynimic Cursors

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 22 Oct 1999 20:12:53 GMT
Message-ID: <3810c4f1.347913234@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 - 15:12:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US