create function raw_to_varchar2(p_raw in long raw) return varchar2 as begin return UTL_RAW.CAST_TO_VARCHAR2(p_raw); end; /SQL> declare 2 a long raw; 3 begin 4 a:=UTL_RAW.CAST_TO_RAW('dddd'); 5 dbms_output.put_line(raw_to_varchar2(a)); 6 end; 7 / dddd
return varchar2
as
begin
return UTL_RAW.CAST_TO_VARCHAR2(p_raw);
end;
/SQL> declare
2 a long raw;
3 begin
4 a:=UTL_RAW.CAST_TO_RAW('dddd');
5 dbms_output.put_line(raw_to_varchar2(a));
6 end;
7 /
dddd