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 AEG