How To Display The Employee Image Stored In The Database In XML Report

T Rajeshbabu

Summary

How To Display The Employee Image Stored In The Database In XML Report

Content

I am using XML Reports with RDF

my sql query is in rdf is

select xxx_getbase64(image) from per_images where parent_id=:p_person_id

FUNCTION xxx_getbase64( p_source BLOB )

  RETURN CLOB

  IS

    v_result CLOB;

  BEGIN

    DBMS_LOB.createtemporary(lob_loc => v_result, CACHE => FALSE, dur => 0);

    Wf_Mail_Util.EncodeBLOB ( p_source, v_result);

    RETURN ( v_result );

  END xxx_getbase64;

and then displaying the image using following XML tags in RTF -

<fo:instream-foreign-object content-type="image/jpg" height="5 cm" width="4 cm"><xsl:value-of select="IMG"/> </fo:instream-foreign-object>

report getting into warning, xml file also not showing anything.

anybody can suggest

Sherry George

Try using a BLOB field. More information in the following document.

Creating RTF Templates