returning a cursor from dynamic sql

From: <Bj.Brandes_at_web.de>
Date: Wed, 08 Nov 2000 20:17:51 GMT
Message-ID: <8uccd5$6sb$1@nnrp1.deja.com>

hi!
does anyone know, how i can return a cursor as parameter from a dynamic sql statement ?

oracle version 8.0.6 for hp-ux

---snip

v_selectstr := v_selectstr || ' select ' || selobj;
v_selectstr := v_selectstr || ' from ' || tabobj;
v_selectstr := v_selectstr || ' where ' || whereobj;
v_dyncursor := DBMS_SQL.OPEN _CURSOR;

DBMS_SQL.PARSE (v_dyncursor,v_selectstr,DBMS_SQL.V7); v_cursorstatus := DBMS_SQL.EXECUTE (v_dyncursor); ????? RETURN v_dyncursor; ?????
---snip

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 08 2000 - 14:17:51 CST