Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news-out.newsfeeds.com!propagator2-maxim!feed-maxim.newsfeeds.com!feed.uncensored-news.com!news.alt.net!plato.usenetgateway.com!not-for-mail
From: gszalach <member34649@dbforums.com>
Newsgroups: comp.databases.oracle.server
Subject: [PL/SQL] Problem with query
Date: Fri, 08 Aug 2003 09:24:50 +0000
Organization: dBforums
Lines: 14
Sender: gszalach
Message-ID: <3216730.1060334690@dbforums.com>
User-Agent: dBforums
X-Original-NNTP-Posting-Host: dbforums.com
X-Original-Trace: 8 Aug 2003 09:24:03 GMT, dbforums.com
X-Authenticated-User: usenetgateway
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240081


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