PL/SQL - Help needed for UTL_FILE

[Jay]

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) ?

Also if I were to concatenate fields by ||, how can I keep a fixed
width format(including whitespaces in the fields ) in the output? 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

[Guido Konsolke]

Again and again and again another one: please don't multipost... 8-[

You received some answer in c.d.o.server.