Re: Dynamic Cursors - How?

hello,

In article <6l21st$5hi$1_at_nnrp1.dejanews.com>, dov_shnaider_at_my-dejanews.com writes:
> 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 ?

take a look at ~oracle/rdbms/admin/dbms_sql.* there is a complete sample in the package

all the packages are self-dokumented

HTH
        peter
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu Jun 04 1998 - 10:14:31 CDT