BI Publisher (MOSC)

MOSC Banner

XML Publisher - Display BLOB Image Dynamically

edited Jan 16, 2019 4:01AM in BI Publisher (MOSC) 1 commentAnswered

hi

i need create XML (RTF) report that showing all employees and signatures, and i have table contains the employee numbers and BLOB column, and these my steps to create a new report but not working with me

1- create a new function

-----

CREATE OR REPLACE FUNCTION xx_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 xx_getbase64;

----

2- create a new rdf with this query

SELECT

CUSTOMER_NUMBER,

DOC_ID,

DOC_NAME,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center