Hi , Are you referring to XML publisher of Oracle ERP , and its OPP logs? If yes, I am not looking for that. I have created independent report in Oracle enterprise BI publisher 11g and scheduled a job for same. Our BI server is running in Weblogic, where i could see the error message I posted in original question above.…

Thanks Thomas for this advice! Well, seems it is concluded that there is no way to pull out textual blob data in BI publisher! Thanks you everyone for sharing your inputs

Hello Thomas, There are two scenarios : 1) If there are 10 records, say 6 of them have null in blob column , and rest 4 have some blob data, It just shows 6 records having null values and does not pulls other 4 records which have blob value! 2) If all the records have some blob data in this column, it shows 'Failed to load…

Hi, we are not using the RTF, but BIP itself to render the report. May i please know, where exactly put the xslfo code ? should it be in layout ? Thanks.

Hi Thomas, I simply do not know why text in blob! its old system. I even have just read access to this DB. well.. meanwhile i tried "utl_raw.cast_to_varchar2(dbms_lob.substr(BLOB_COLUMN, 100))" , but it just does not pulls out the data.

Hi Sherry, It is Text ! According to https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-58D7E662-146A-44AA-86F9-111E2C6DB3A5.htm#BIPRD2396 , it looks like only image data can be shown in BI publisher report! Still could there be any work-around for this ? Thanks!