Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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