Re: [PL/SQL] Problem with query

From: mitt <nospam_at_nospam.at>
Date: Fri, 08 Aug 2003 11:49:27 +0200
Message-ID: <3F337227.4010202@nospam.at>

gszalach wrote:
> Hi,
>
> In many modules of my application I assume that i do not know name of
> columns of the table. So I query dba_tab_columns for the names.

no good idea! except you want horrible performance;(

> I don't know how to build query returning values for all these columns.
> I can't use 'execute immediate' because I can't use as output parameter
> variable 'row MyTableName%rowtype'.
> Do you have any ideas how to resolve this problem??

take a look at oracle supplied package DBMS_SQL; more or less any kind of dynamic sql, which cannot be done with "execute immediate" can be done with good old dbms_sql package; Received on Fri Aug 08 2003 - 04:49:27 CDT