Utl_file.Get_line Doesn't See All Line Terminators in a File (Doc ID 1313942.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 27-Nov-2012***

Symptoms

When reading a windows-created file on an unix database server with UTL_FILE and there are special characters (like é, è, ß) on the end of the line (record) then the lines (records) will be together (this means instead of 2 records there are only 1 record).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms