Oracle Database Discussions

Hi All,

I did some interfaces to data upload data from external applications to Oracle Database. So I export the data in to a .csv and update it to the Oracle.
I have used both external tables and utl.file methods.
But In both methods i found a common issue, that is the last column in the csv file updates with an <enter>. (Please find the link for more details).
It returns error when interfacing, ( I used trim function also).
So Every time i update a temp column as last and i did the interfacing part.
But when it comes to automation I have no way to do this.

Please help me to solve this issue.

Thanks