topic Report question for BLOB data type in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/report-question-for-blob-data-type/m-p/11013056#M1897416 <HTML><HEAD></HEAD><BODY><P>I'm creating a report to show the email archives, but I can't get the body to display because it's a data type of BLOB.&nbsp; Does anyone know how to get a BLOB to display in a report?</P></BODY></HTML> Mon, 13 Apr 2015 16:54:23 GMT SteveSherrod 2015-04-13T16:54:23Z Report question for BLOB data type https://community.sap.com/t5/application-development-and-automation-discussions/report-question-for-blob-data-type/m-p/11013056#M1897416 <HTML><HEAD></HEAD><BODY><P>I'm creating a report to show the email archives, but I can't get the body to display because it's a data type of BLOB.&nbsp; Does anyone know how to get a BLOB to display in a report?</P></BODY></HTML> Mon, 13 Apr 2015 16:54:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/report-question-for-blob-data-type/m-p/11013056#M1897416 SteveSherrod 2015-04-13T16:54:23Z Re: Report question for BLOB data type https://community.sap.com/t5/application-development-and-automation-discussions/report-question-for-blob-data-type/m-p/11013057#M1897417 <HTML><HEAD></HEAD><BODY><P>I was able to get this to work using the following in the select statment of my query:</P><P></P><P></P><P></P><P><SPAN style="color: black; font-family: 'Courier New';">to_char(UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(body,<BR />2000,1)))&nbsp; body</SPAN></P></BODY></HTML> Tue, 16 Jun 2015 20:27:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/report-question-for-blob-data-type/m-p/11013057#M1897417 SteveSherrod 2015-06-16T20:27:09Z