Can we interpret Oracle BLOB data in SAP MII and how?

[Former Member]

Hi Experts,

I have a situation here, where have an oracle database and data is getting stored in BLOB column. This data can be an image or text or any other format.

Is it possible to interpret this data in SAP MII and show it on the dashboard? and How?

is this possible directly? or we need to create custom actions for it.

Thank you in advance.

Regards,

Gita

[Nikhil_Makhija]

Hi Gita,

I think you need to apply dbms_lob package to work with it.

select utl_raw.cast_to_varchar2(dbms_lob.substr(BLOB_FIELD)) from TABLE_WITH_BLOB where ID = '<row id>';

See if it works.

Regards

Nikhil

[rutika_bodas]

Hi Gita,

It is possible to read the BLOB data using MII.

See the following thread. Its not exact case as yours, but might be useful.

Retrieving BLOB data using MII | SCN

Hope it helps,

Regards,

Rutika Bodas

Correction:

Gita,

I investigated more on this and tried to create a query that fetches data from my BLOB type of column. Guess what, it FAILED. 

On running the query, it gave an exception stating that 'BLOB" type of data cannot be fetched as Java type 'String'.

Perhaps, there is no straightforward way to read the BLOB data from a query in MII. Not sure if there's some other way.

Regards,

Rutika

Message was edited by: Rutika Bodas