Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to print a rowtype variable!

Re: How to print a rowtype variable!

From: Emre Akbag <akbag_at_scr.siemens.com>
Date: Wed, 6 Sep 2000 11:50:16 -0400
Message-ID: <jFtt5.642$zx3.8781@iad-read.news.verio.net>

Thanks for the answer.
But, my main problem is printing a row without supplying the column names. That's the reason, why I'm trying to use rowtype of variable.

"Ivar Stolfot" <Ivar.Stolfot_at_abs.ee> wrote in message news:39b66490$0$206_at_diablo.uninet.ee...
> dbms_output.put_line('Column1:'||l_rowtype.column1||'
> Column2:'||l_rowtype.column2);
>
> "Emre Akbag" <akbag_at_scr.siemens.com> wrote in message
> news:vtst5.454$zx3.9242_at_iad-read.news.verio.net...
> > How can I print a row-type variable?
> >
> > dbms_output.put_line doesn't work (I receive 'Wrong number or type of
> > arguments!'). Then I tried to convert it using to_char function.
> > But, this function doesn't work, neither, because of the same reason.
> >
> > Any ideas?
> >
> >
> > --
> > Emre AKBAG
> >
> > Data Mining, Imaging & Visualization Dept.
> > Siemens Corporate Research
> >
> > Ph: (609) 734.6500 ext. 2260 Fax: (609) 734.6565
> > E-mail: akbag_at_scr.siemens.com
> >
> > Siemens Corporate Research,
> > 755 College Rd East,
> > Princeton, NJ 08540
> >
> >
>
>
Received on Wed Sep 06 2000 - 10:50:16 CDT

Original text of this message

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