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 -> Dynamic Cursors - How?

Dynamic Cursors - How?

From: <dov_shnaider_at_my-dejanews.com>
Date: Tue, 02 Jun 1998 23:29:34 GMT
Message-ID: <6l21st$5hi$1@nnrp1.dejanews.com>


Hi,
I need to create a cursor dynamically ( including the Select, The From and The Where statements ). I am trying to use the DBMS_SQL package but... I don't see how to create a dynamic "dbms_sql.define_column(" and "dbms_sql.column_value" statements. So, I can parse a dynamic SELECT statement but I can not dynamically retrieve the values. Any ideas ?

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 02 1998 - 18:29:34 CDT

Original text of this message

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