Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE PACKAGE
In article <5v7j0m$gr_at_bgtnsc02.worldnet.att.net>, BHAVESH PATEL
<BHAVESH-PATEL_at_worldnet.att.net> writes
>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.
>
>Bhaevsh
>Bhavesh-patel_at_worldnet.att.net
Bhavesh,
The only workaround I know is to split your lines to around the 1000 bytes and add a magic character to indicate that the line has been split. You then write an external routine to rejoin the affected lines.
Not nice.
Andy
-- Andy Hardy Senior IT Systems Engineer Cegelec AEG ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Opinions are mine and do not necessarily reflect those of Cegelec AEGReceived on Thu Sep 11 1997 - 00:00:00 CDT
![]() |
![]() |