PL/SQL UTF_FILE.PUT_LINE does not add a new line

Question

I've created a procedure that writes text to a file yet for some reason I'm not able to create a new line through the code and the end result is that the procedure writes everything to the same line until it breaks to a new line due to size. this is how the code looks:

logFileHand := UTL_FILE.FOPEN('LOGS' , logName, 'A');
UTL_FILE.PUT_LINE(logFileHand, LOG_TS || '   ' || LOG_INSTANCE || '   ' || LOG_USER ||    
'   ' || LOG_PROGRAM || '   ' || LOG_LEVEL || '   ' || LOG_TEXT);
UTL_FILE.PUT_LINE(logFileHand, 'test');
UTL_FILE.FCLOSE(logFileHand);

file looks like this after 1 run of this procedure:

30-DEC-13 03.43.03.341466 PM 1 LPSQL TABLET_PARTY.GETSP TABLET_PARTY.GET ERR SQL Error: 100 Could not find the party details for ID: 200144095test

as you can see everything is on the same line, I've tried every variation of PUT functions and nothing helped. Any ideas? thanks alot in advance!

`PUT_LINE terminates the line with the platform-specific line terminator character or characters.` Which text editor do you use to open your file? What is your server and client OS'es? There is difference how unix-like systems and Windows treats line terminator character. — Yaroslav Shabalin, Dec 30 '13 at 14:34
@user30500187 What is your server OS? How do you get file from the directory where it is written to (do you copy it from server somehow)? Or you have server (i.e. XE edition) on your local machine? — Yaroslav Shabalin, Dec 30 '13 at 14:50
Redhat Linux, it writes the file to a shared library which I can access as a network location. — user3050187, Dec 30 '13 at 14:54

score 0 · Accepted Answer · edited May 23 '17 at 10:32

Your lines appears to be not split because unix-like OS's and windows have different conventions on what is treated as line separator. For more details look at answer to this question. You have two options to get lines properly separated.

Setup your text editor properly. I.e. in Notepad++ you should choose Edit -> EOL Conversion -> Convert to Windows Format. Then save your file and reopen it.
Make your procedure to write log file with Windows line separators. This approach is questionable. If these files are supposed to be used in any way on the server which have linux OS then it should has native format.

PL/SQL UTF_FILE.PUT_LINE does not add a new line

1 Answers1