This content has been marked as final. Show 2 replies
Can you post the UTL_FILE code you're using to open the file and write the data? Have you opened the file in a hex editor to confirm that the unexpected line breaks exist in the file before you run the import process and that these aren't artifacts of whatever import process you're running? Have you DUMP'd the data from the VARCHAR2(500) variable to confirm that there are no line breaks in the data?
Thanks for your reply, the problem is with the data.
I just exported to excel and it shows like that with the squares showing the break.
Edited by: N K on Dec 11, 2012 7:25 AM