Using images stored in BLOB field

[willphill]

I saw this post a few years ago and was wondering if anyone was able to get it to work. I am trying to pull images directly from a BLOB field stored in Oracle. Any help is much appreciated.
This was a similar post:
I have a problem I would like to run by y'all.

1) I create a Framework Manager project called "Channel Logos" and import one table called "Logos".

2) The table "Logos" has 5 attributes:
-ID (unique ID)
-Logo Name
-Logo Description
-File name (e.g. "HBO.jpg")
-Graphic (where "HBO.jpg" is stored as Blob datatype).

NB: Framework manager successfully detected the datatypes of all 5 attributes.

3) The "Data Type" property for GRAPHIC attribute is set to `BLOB`.

4) I set the "Display Type" property for GRAPHIC attribute to `Picture`.

5) I set the "Mime Type" property for GRAPHIC attribute to `jpg`.

I create a package called "LOGOS" and export it my server.

6) I launch Report Studio, select the package called "LOGOS"  and create a basic list report  by dragging/dropping the 5 columns from the "Logos" table onto my work area.

NB: the GRAPHIC column is rendered with the graphic icon.

7) I run the report: all columns are shown, expect GRAPHIC that is displayed with a RED cross (e.g. a picture that cannot be displayed on a web site).

NB: I tried changing the "Display Type" property to `value` and `link` but to no avail. Changing the "Mime Type" to "jpeg" was unsuccessful too.


Am I missing something or is not simply not feasible?

[melllvar]

Hi

I've just been on FM training.  The trainer mentioned that when using blobs, you have to use determinants.  He didnt show us how, but i didnt see that in your list.

Hope it helps

Ritch