Re: dbms_sql question

From: Roman Rahimov <roman_at_santel.ru>
Date: Mon, 29 Jan 2001 16:06:29 +0300
Message-ID: <953q14$2chn$1@serv2.vsi.ru>

Hello!

> I don't know how many columns are being selected, nor what these
> columns are, so is there a way to get this information?

In my opinion there're two ways to decide this problem. First is you should take a grammatical parse of SQL statement. Or second is you should give to PL/SQL all necessary information in any structure , for ex. in PL/SQL table.

(pSQL in varchar2,whatFields in FieldTable) is

in whatFields you should define columns and their type

Somehow or other on current level of skill I see no other ways to determine count and type of columns in any cursor by PL/SQL code.

Good luck! Received on Mon Jan 29 2001 - 07:06:29 CST