Problem while using UTL_FILE.PUT
Posted on 2003-02-20
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,