Ad,

Try the following code using ULT_RAW if you haven't done so.

-------------------------------------------------------------

/*Problem description*/
To convert long raw to varchar

/*proposed solution*/


1. Create utl_raw package specification in $ORACLE_HOME\rdbms\admin\utlraw.sql.
2. create utl_raw package body in $ORACLE_HOME\rdbms\admin\prvtrawb.plb
3. When you want to convert raw to character , fetch into a cursor and then convert.

declare
a varchar(255);
b long raw;
cursor c1 is select long_raw from raw_table;
begin
open c1;
loop
fetch c1 into b ;
exit when c1%notfound;
a:=UTL_RAW.CAST_TO_VARCHAR2(b);
dbms_output.put_line(a);
end loop;
end;