Retrieveing an image of BLOB datatype from Oracle DB and displaying the same in the Deski Reports

[kamalessh]

Hi all,

     I am using BOXI 6.5 . I need to retrieve an image of BLOB datatype from oracle DB and have to display it in the deski reports. I have tried using Dbms_lob.substr(Table.CLOB_Column , number of characters, start position). nothing worked out. I have found from various forums and blogs that BLOB can't be accessed in Universe.Kindly suggest a way to achieve this.

Regards,

Kamalessh.

[former_member188911]

Hi Kamalessh

CLOB data type was not supported in BOBJ 6.5

you must convert the field to a supported one.

The guide that explains what types of supported data types is the Data Access Guide.

Thanks

Simone

[kamalessh]

Hi Simone, 

     Could you please provide me an example for data conversion . It will be easy for me to understrand.

Thanks,

Kamalessh

[former_member188911]

For images there is nothing you can do,  you must store the images physically on a server as separate images and load them as such.

Other types of data you can convert them to the closest type of representation (i.e. varchar, etc.)

Cheers

Simone