Hi to all,
Created one text file using procedure and moved to FTP folder. Text file opened thru IE its working fine. Copied into local machine and open in notepad its not working i.e, appeared in continuous line. Wrap text also checked its correct only
Code :
Declare
Begin
v_File_Name := utl_file.fopen ( Dir_Obj_Name, File_Name, 'W' );
For Cur In (Select 'One' A1, 'Two' A2, 'Three' A3 From Dual
Union
Select 'Four' A1, 'Five' A2, 'Six' A3 From Dual
)
Loop
v_line_Text : = Cur.A1 || ' ' || Cur.A2 || ' ' || Cur.A3 || ' ' || Chr(13);
utl_file.put_line(v_File_Name , v_line_Text, True );
End Loop;
utl_file.fclose(v_File_Name);
End;
Excepted Ouput
One Two Three
Four Five Six