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 -> [PL/SQL] Problem with query

[PL/SQL] Problem with query

From: gszalach <member34649_at_dbforums.com>
Date: Fri, 08 Aug 2003 09:24:50 +0000
Message-ID: <3216730.1060334690@dbforums.com>

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. 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??

szalas

--
Posted via http://dbforums.com
Received on Fri Aug 08 2003 - 04:24:50 CDT

Original text of this message

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