Try to think of UTL_FILE is simular as DBMS_OUTPUT except file handle
will things easlier.
yinshu
Jay wrote:
> "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 - 19:51:05 CST
