Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Records having Blob data not shown in the BI report
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!
Answers
-
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
0 -
-
why BLOB for text? ... why not CLOB? was this a custom add?
0 -
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!
0 -
Do you get any error
or just that column in your rows is blank
or no rows?
0 -
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.
0 -
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.
0 -
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.
0 -
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.
0 -
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
0