7 Replies Latest reply on Dec 11, 2018 10:27 AM by Stew Ashton

    Unable to read CRLF file in oracle


      I am trying to read a file which is sent by an external system to our server and load it into a oracle database table. I am using the utl_file package to read the data from the file. When I am creating the file with similar contents in the unix environment it is getting it read by my oracle code but the same is not working on the file we are receiving from the external system. On researching I found that the file sent by external system is of type ISO-8859 text, with CRLF line terminators whereas the one I have created in the unix environment is of type UTF-8 Unicode text. Can someone please provide some inputs on the same.

      Below is the output of

      select *

      from sys.v_$parameter

      where name like 'nls_lang%'