Hi All, Can you please advise on approach of how to get text out of BLOB column. We store XML data within these BLOB column and I have to display certain elements out of it. So would use regular exp to find exact elements once converted into text but more interested to know best way to convert BLOB to text. Initially tried --> select UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(BLOB_COL, 4000,1)) from BLOB_TABLE; But because my col data avg size is 200000 bytes, I cannot use that approach. Should I convert it to CLOB and then to text or any advice on how to proceed further in efficient way ? DB Version: --------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit PL/SQL Release 11.2.0.3.0 CORE 11.2.0.3.0 TNS for Linux: Version 11.2.0.3.0 NLSRTL Version 11.2.0.3.0