I am reading a file using utl_file package, this file contains a word "hämorrhagic"
Now, I use utl_file.fopen_nchar()
But, sooner sys owned package reads it from text file, it got distorted as a Junk character "h rrhage"
-----------------------
I've a solution to write a multibyte character, by converting the special text into raw using UTL_RAW.CAST_TO_RAW function
which means, if I place "hämorrhagic" in a variable and before writing it to text file, I utl_file.put_line(use utl_raw.cast_to_raw(l_string));
it gets written back as "hämorrhagic"
My ask is, is there any way to read the text file in Oracle directory directly as RAW ? so far there is not oracle procedure to do so.
Any help would be much appreciated.