filedname as variable in dbms_outpu

From: Detlef Kandziora <kancom_at_bigfoot.com>
Date: Wed, 06 Dec 2000 00:10:08 GMT
Message-ID: <3a2d80ff.14333250@news.arcor-ip.de>

Hi,

I want to display the content of a list of fields, but in something like a for - loop.

The table has numbered columns (filed1...filed10)

I generate a variable for the filednames and catch all contents of the tabel in a record (with rowtype%).

I've done a simple Loop like this:

for i in 1..10 loop

	f_nam :='field'||i;
	dbms_output.put_line (f_name);

end loop;

This shows only the fieldnames, but I need the field-content from the rec_tab, but I can't do something like this (it's the same useless thing than above):

for i in 1..10 loop

	f_nam :='rec_tab.field'||i;
	dbms_output.put_line (f_name);

end loop;

Isn'r there something like a content-function for a variable ?

thanks for any tip Detlef

P.S.: Please reply only to mail-adress ! I can't access news-groups in the office, but will post the answers later Received on Tue Dec 05 2000 - 18:10:08 CST