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

Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE PACKAGE

Re: UTL_FILE PACKAGE

From: Finn Ellebaek Nielsen <ellebuk_at_post3.tele.dk>
Date: 1997/09/11
Message-ID: <341790D6.ADB1BFD2@post3.tele.dk>#1/1

BHAVESH PATEL wrote:
>
> Hi
>
> Can any one help in the below issue.
>
> I want to write into a flat file in a specific format using
> UTL_FILE.PUT_LINE.
> the line which I want to write to the file is more than 1024 bytes and the
> PUT_LINE or rather UTL_FILE can supports only 1024 bytes.
>
> Is there any way to write a such a big line to a flat file using the
> UTL_FILE package. If so please try to help me in the above issue. and
> thanks in advance for the same.

Use UTL_FILE.PUT or UTL_FILE.PUTF.

Cheers,

Finn

-- 
--------------------------------------------------------------------------------
 Finn Ellebaek Nielsen          Oracle Associated Senior Consultant
 Ellebaek Consulting            E-mail:           ellebuk_at_post3.tele.dk
 Niels Ebbesens Vej 9, 3. th.   Mobile Phone:     +45 20 32 49 25
 DK-1911  Frederiksberg C       Mobile Phone SMS: 20324925_at_sms.tdm.dk (Subject)
 Denmark                        Private Phone:    +45 33 25 34 50
--------------------------------------------------------------------------------
 "Life is a beach and then you dive"                      "Divers do it deeper"
Received on Thu Sep 11 1997 - 00:00:00 CDT

Original text of this message

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