Re: UTL_FILE - Help

"Guido Konsolke" <dueto.spam_at_nomail.com> wrote in message news:<1079534693.639330_at_news.thyssen.com>...
> Hi Jay,
>
> comments inline...
>
> "Jay" wrote...
> > Hi All,
> >
> > Suppose I have cursor called EMP (multiple fields) and record is
> > defined as
> >
> > EMP_REC EMP%ROWTYPE;
> >
> > Is it possible to use UTL_FILE.PUT_LINE(file1, EMP_REC) ?
>
> What don't you simply try it?
>

I tried it and it says imcorrect number of arguments...Any other to do this?

Thanks!

> >
> > Also if I were to concatenate fields by ||, how can I keep a fixed
> > width format(including whitespaces in the fields ) in the output?
>
> PAD the variables or use the appropriate datatype.
>
> > I meant to say
> > if I do fname || lname, I want the output
> >
> > John Saxon
> > Kelly Mitchell
> > Patricia Hall
> >
> > rather than
> >
> > JohnSaxon
> > KellyMitchell
> > PatriciaHall
> >
> > THANKS A LOT!!!!
> >
> > J
>
> hth,
> Guido
Received on Wed Mar 17 2004 - 15:55:47 CST