UTL_FILE question

[BADCODER]

I am using a cursor to fetch value into a variable, then write this variable to a file.

QUESTION:
*********

Everytime the loop is executed, the variable v_select is written to a new line in the file.

Is there a way to ignore line feed and write the entire output in ONE SINGLE line?


CODE:
******************************
BEGIN
id := UTL_FILE.FOPEN('/mydir','myfile,'a');
UTL_FILE.PUT_LINE(id,'myfile');
LOOP
FETCH p_Cur INTO v_select;
EXIT WHEN p_Cur%NOTFOUND;
UTL_FILE.PUTF(id,v_select);
END LOOP;
UTL_FILE.FCLOSE(id);
CLOSE p_Cur;
END;
*******************************

 

[SantaMufasa]

Bad,

Just say, "UTL_FILE.PUT(...", which "stages" the data for output, then when you are ready to actually output that which you have staged, you may say, "utl_file.fflush(...".

Let me know if this behaves as you wish,

Dave
Sandy, Utah, USA @ 23:79 GMT, 16:40 Mountain Time