PL/SQL UTL_RAW.CAST_TO_RAW problem reading HEX data field with utl_file

[Quoted] [Quoted] Oracle 11.2.0.1.0 running on SunOS 5.10.

[Quoted] I am encountering a PL/SQL problem with UTL_RAW.CAST_TO_RAW and can use some help.

I am reading and processing an input file that is a mix of ascii and hex fields.

Here is a snippet of the processing for the hex field in question:

  w_input_line CHAR(187); -- space for the input record   raw_hex_field raw(2);

1. UTL_FILE.GET_LINE(w_file_handle, w_input_line);
2. raw_hex_field := UTL_RAW.CAST_TO_RAW (substr(w_input_line, 93, 2));

This works fine for hex values x'0009', x'000B' and x'FFFF' but has a problem with x'000A':

Here is some debugging output:

  dbms_output.put_line ('raw_hex_field: ' || '>' || raw_hex_field || '<' );

  raw_hex_field: >0009<
  raw_hex_field: >000B<
  raw_hex_field: >FFFF<
  raw_hex_field: >00<            <<<<<<<<<<<<<<<<<<<<<<<<<<<<< HUH?

This is what I would hope to see:

  SQL->exec dbms_output.put_line( '>' || utl_raw.cast_to_raw( chr(00) || chr(10) ) || '<');
>000A<

  PL/SQL procedure successfully completed.

Is it possibly interpreting x'0A' as a line feed?

Changing the input record format is not an option for us. Can anyone help to resolve this?

TIA Luke Received on Fri Apr 30 2010 - 01:42:54 CEST