Re: How to print a rowtype variable!

You can create a function for this if you use often dbms_output statement to get record information for one table: dbms_output.put_line(get_emp_info(emp_rec));

"Emre Akbag" <akbag_at_scr.siemens.com> wrote in message news:jFtt5.642$zx3.8781_at_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 Thu Sep 07 2000 - 09:55:26 CEST