How to get the text file from blob, I tried using :

SELECT UTL_I18N.RAW_TO_CHAR(dbms_lob.substr(BLOB_FILE),'AL32UTF8') 
FROM TABLE;

Also I tried :

SELECT utl_raw.cast_to_varchar2(dbms_lob.substr(BLOB_FILE)) 
FROM TABLE 

But getting values like this :

xœXÛrÛ6}×LÿAõ;Ã8íC&¡Ò€liª›EÉžN&£Èµ„š"TŽ­¿ï„x!'¶°ç,€åb±`yN¶àŒÂ/}ϹüôLJÆß_{݇þuoB÷à<

How can we convert blob file to text?

0

There are 0 best solutions below