SQL & PL/SQL

Hi all,

I am trying to use a control character CHR(253) as a delimiter.  The script works fine in 11i put when I use the same code in R12 its not printing the control character.

v_dem VARCHAR2(10) := CHR(253);

UTL_FILE.PUT(v_handle, '1111');

UTL_FILE.PUT(v_handle, v_dem);

UTL_FILE.PUT(v_handle, '2222');

This does not print the control character.

When I use cat -v output_file.csv, its showing the control character in Unix in 11i, but in R12 its just not printing the control character.

Thanks for you help and time.