Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need RTF template to use url:{LOGO_PATH} syntax to show image

Simon GaddJun 4 2008 — edited Oct 26 2010
Hi Folks.

I have company logos stored in my database as JPEG files in a BLOB column.

I can upload and download these with no problem.

What I'd like to do is return these BLOB images (one per row of data) to a report Template (RTF Named Columns) which then gets generated as a PDF file.

At the moment, if I include the BLOB image in the query, the resulting XML file states...
<LOGO>[unsupported data type]</LOGO>

.. at the location of the LOGO element.

Do I need to do something different to get the BLOB data output or is it simply not possible to do this?

My alternative would be to save the logo to a www server and build in the logo URL to the template. Not sure if I could specify a dynamic URL though as the logos would change from row to row being reported.

Any thoughts/comments appreciated.

Dogfighter.

Message was edited by:
Dogfighter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2010
Added on Jun 4 2008
11 comments
11,487 views