Felipe Vidal
Active Member
Hi,
I'm trying to convert the BLOB file of a data structure pulled from F98743. However, using UTL_RAW.CAST_TO_VARCHAR2, HETTORAW & DBMS_LOB.SUBSTR is giving me weird results. I have relied on these functions to convert versions' BLOBs. I'm not sure if I'm doing something wrong.
My query is
[SELECT
DTOBNM,
UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW(REPLACE(DBMS_LOB.SUBSTR(DTERBLOB, 900), '00', '')))
FROM PD920.F98743 WHERE DTOBNM = 'D0101201';]
The result I'm getting is "ßs8ßï¯`xjoæjK®sS§C..." (& much more) which... says nothing
What am I doing wrong?
I'm trying to convert the BLOB file of a data structure pulled from F98743. However, using UTL_RAW.CAST_TO_VARCHAR2, HETTORAW & DBMS_LOB.SUBSTR is giving me weird results. I have relied on these functions to convert versions' BLOBs. I'm not sure if I'm doing something wrong.
My query is
[SELECT
DTOBNM,
UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW(REPLACE(DBMS_LOB.SUBSTR(DTERBLOB, 900), '00', '')))
FROM PD920.F98743 WHERE DTOBNM = 'D0101201';]
The result I'm getting is "ßs8ßï¯`xjoæjK®sS§C..." (& much more) which... says nothing
What am I doing wrong?