Re: filedname as variable in dbms_outpu

Betreff:

            Re:        fieldname as variable in dbms_outpu
     Datum:         Wed, 06 Dec 2000 12:34:29 +0100
       Von:            Markus Schwabe <mschwabe_at_gscout.de>
        An:             Detlef Kandziora <kancom_at_bigfoot.com>

Hi,

sorry, no way. You can not handle a Column-name like a content of a variable.
Forget the loop and write down ten times dbms_output. (if you get another answer (and this works), then feel free to correct me.)

Markus

On Wed, 06 Dec 2000 00:10:08 GMT, kancom_at_bigfoot.com (Detlef Kandziora) wrote:

>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 Wed Dec 06 2000 - 17:18:01 CST