Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_FILE.GET_LINE reads two lines

user11078372Jan 24 2012 — edited Jan 24 2012
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??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2012
Added on Jan 24 2012
7 comments
730 views