| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> How to handle newlines in files via PL/SQL
Hi, I need help with the followin procedure:
Procedure TEST
IS
file_in UTL_FILE.FILE_TYPE;
BEGIN
file_in := UTL_FILE.FOPEN ('F:\SAPJ\Files', 'koez.txt', 'W');
UTL_FILE.PUT (file_in, '1');
UTL_FILE.PUT (file_in, '11');
UTL_FILE.NEW_LINE (file_in);
UTL_FILE.PUT (file_in, '2');
UTL_FILE.FCLOSE(file_in);
Output:
row 1: 111
row 2: 2
row 3:
!jani Received on Thu Jun 27 2002 - 06:10:02 CDT
![]() |
![]() |