Problem while using UTL_FILE.PUT

Hi All,

I am writing to a file using UTL_FILE.PUT command. The header of the file is of 2600 chacters. Whenever I use the command, it gives me an error. Hence I tried to write after spliting the big string into 4 parts , but in any case it is giving me the same error.

I understand the maximum size for output record is 1023 bytes. It alls me to write on the next line (using UTL_FILE.PUT_LINE command).

But my requirement states that the header should be a single line since the file is later use for SQL import. Can anyone help me with this.? I do not want to have CRLF (Line feed) after 1023 characters? Is it possible to do so?

Thanks in advance,
Pankaj