Records having Blob data not shown in the BI report

Manishachoudhary

Summary

Records having Blob data not shown in the BI report

Content

Hi,

we are using BI publisher 11.1.1 , however I am new to this area.

I have connected to oracle database were there is a column with BLOB data type.  All the records having null in that column are shown but records which have some blob data in this column are not rendered in my report!

Could anyone please guide me, how to handle this ?

Or may be I first need to know how to work with blob data in BI reports. Please help.

Thanks in advance!

Sherry George

Hi Manisha,

What is the content in this BLOB column? Text/Image?

Take a look at these links

https://stackoverflow.com/questions/828650/how-do-i-get-textual-contents-from-blob-in-oracle-sql

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-58D7E662-146A-44AA-86F9-111E2C6DB3A5.htm#BIPRD2396

Carlos Carvalho

Hello,

I have done it for image only ( ).

Never tried text, but if you do as if it was an image what happens?

Regards,

Carlos

Thomas Dodds

why BLOB for text? ... why not CLOB?  was this a custom add?

Manishachoudhary

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!

Thomas Dodds

Do you get any error

or just that column in your rows is blank

or no rows?

Manishachoudhary

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.

Manishachoudhary

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.

Thomas Dodds

Your best bet is to have the DBA materialize a view that has the BLOB converted to varchar2 in and by the database ...  CLOB is for CHARACTER LONG OBJECTS (text) - they have a data typing issue.

Manishachoudhary

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 xml'  error in windows alert box.

Manishachoudhary

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