Hello Experts,
We have a strange issue when we write the data to a text file. Data file contains two rows for each record just like the way it is displayed in DB.
But when we manually export it from the toad it is coming in one line. we need it to be in one line as the data file is a feed for another system.
Create or replace PROCEDURE Test
IS
xfile UTL_FILE.file_type;
BEGIN
xfile := UTL_FILE.fopen ('IT_BI', 'Test_DAILY_New.txt', 'W');
FOR c IN
(SELECT 'ID_NUMBER'||'**'||'RECVFromAddress' x_file
FROM DUAL
------------------------------------------
UNION ALL
------------------------------------------
SELECT DISTINCT ID_Number||'**'||RECVFromAddress
FROM Test\_Table
)
LOOP
UTL_FILE.put_line (xfile, c.x_file);
END LOOP;
UTL_FILE.fclose (xfile);
END ;
London Finance House London should be in one line in the file . Instead it is coming down as two lines.
Data viewed from Toad has also two lines.
Thank you all,