UTL_FILE.GET_LINE reads two lines
Hi:)
I have problem while reading a file. Normaly my package works fine, but yeastarday our customer told us that concurrent program finished with error. The problem is that utl_file.get_line reads two lines in one loop.
Normaly I should get:
line 1: ^64100 TORUă
line 2: :61:1201200120CN000000000150,00N240NONREF
but now I get:
line 1: ^64100 TORUă
:61:1201200120CN000000000150,00N240NONREF
I get file from bank in code page EE8PC852. My DB NLS_CHARACTERSET= UTF8, NLS_NCHAR_CHARACTERSET=AL16UTF16
In Hex these two lines looks like below:
TEXT:
(..)TORUă
:61:12(...)
HEX:
54 4F 52 55 E3 0D 0A 3A 36 31 3A 31 30
So everything looks OK... there is 'NEW LINE' separator.
In my opinion problem is with character 'ă' hex: E3.
When I remove it with normal character 'N' my package works fine.
I tried to open that file in 'RB' mode but then I get:
line 1: ^64100 TORUă :61:1201200120CN000000000150,00N240NONREF
so still error.
Any idea??