Problem in chr(10) function of a PL/SQL procedure
Foremost a preview of what I am doing:
I have a UTL_FILE procedure in Oracle 9i to write some text to a txt file. As this text file is large exceeding 32 K (UTL_FILE has its limitations that it cannot write more than 32K of data at one go), what I do is to add multiple rows of 32K each to a CLOB column of a table. Thereby, using the UTL_FLE function, I transfer this chunk of data from the table to the txt file using a LOOP.
Now, this text which I am finally transferring to a txt file has some headings like Borrower Segment, Credit Facility Segment etc. The requirement is that after supplying data to each of this heading the next data must start in a new line. When I first transfer data to the table in chunks of 32K, I use the chr(10) function to achieve the new line target. It works fine.