Re: dbms_sql question

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: Mon, 29 Jan 2001 21:20:18 GMT
Message-ID: <954mq5$h49$1@nnrp1.deja.com>

Hi.

You have to use DBMS_SQL.DESCRIBE_COLUMNS procedure.

HTH. Michael.

In article <t7a9evamknlh4d_at_xo.supernews.co.uk>, "Jeremy Ovenden" <jovenden_at_hazelweb.co.uk> wrote:
> Suppose we have a piece of SQL which is unknown, e.g. it might be
>
> select ename,dept
> from emp;
>
> or it could be
>
> select col1,col2,col3
> from tab1 a,
> tab2 b
> where a.
> .... etc
>
> What I would like to do is execute this piece of SQL using dbms_sql but
> would like to be able to get the data returned by the select into pl/sql
> variables.
>
> My question is: (how) can I identify the columns that are being selected?
>
> BTW looking for a solution on 8.0.5+
>
> --
>
> Jeremy
>
>

Sent via Deja.com
http://www.deja.com/ Received on Mon Jan 29 2001 - 15:20:18 CST