How to display BLOB field?

[ajneedshelp]

Hi

I am using Crystal ver 9. I want to display a BLOB field on the report, not sure how to do it.

Thanks!
-AJ

 

[hilfy]

What database are you using? How are you connecting to it - ODBC, Native connection, etc.? What's in the BLOB field that you want to display?

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[ajneedshelp]

I am using oracle 10g and ODBC connection.

 

[dgillz]

Please answer ALL of the questions by hilfy.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[ajneedshelp]

Database: Oracle 10G
Connection: ODBC - Driver: CR Oracle ODBC Driver4.10

The field would multiple addresses in it (stored as a Blob)

 

[CoSpringsGuy]

for what its worth ...

I think I remember that Oracle has some SQL structure that will covert BLOB to Varchar (if it is text and not an image). I have no idea how to use it or where to get info on it but maybe that will send you in the right direction? From there you will probably have to create an SQL command and the field should no longer be a BLOB. My Oracle experience fortunately didnt last more thatn a week or so.

Good luck

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[chelseatech]

BLOB fileds should work okay if it contains a valid Crystal Reports image type. For example BMP and JPG will be okay, but GIF is not supported.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[hilfy]

My experience has been that blobs don't work through an ODBC connection from Oracle - you have to use a native connection.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[musini]

BLOB can not be directly displayed in the reprot just with a select and the column name. try googling the extract function in oracle. first you need to extract the particular coulmn in BLOB. What I mean is BLOB has large strings it may or may not be one single column value in it. you need to extract the exact value what you need depending from the BLOB.

Thanks
M

 

[hilfy]

Blobs that contain image files can be directly displayed. Clobs with text can be directly displayed (IIRC). However, I can see how a Blob with non-binary text data would have to be converted to text in order to be available on a report.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.