SQL>
SQL> select utl_raw.cast_to_varchar2(hextoraw('787878')) from dual;
UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW('787878'))
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
xxx
SQL>