Tuesday, April 14, 2009

New Web Services Integration White Paper and Sample Application on OTN

Late last year I promised a white paper and sample application on integrating Application Express and BI Publisher through Web services. Well five months later (hey, that's less than 1/2 a year), it is now available on the Application Express Web Services Integration page on OTN. The sample application allows you to login to a BI Publisher instance as a BI Publisher defined user, browse the folders and reports available to that user, and provides the ability to download the report all from within the Application Express application. The white paper describes in detail how to build the application using PL/SQL and the flex_ws_api package. I hope you find it useful.


Dimitri Gielis said...

Very nice! Well done Jason.


[RISC] said...

Hi Jason,
Any change you could add a clobbase642clob function to your package? Best regards,


Jason Straub said...


Would the following function work for you?

function clobbase642clob (
p_clob in clob ) return clob
pos pls_integer := 1;
buffer raw(36);
res clob;
lob_len integer := dbms_lob.getlength (p_clob);
l_width pls_integer := (76 / 4 * 3)-9;
dbms_lob.createtemporary (res, true);
dbms_lob.open (res, dbms_lob.lob_readwrite);

while (pos < lob_len) loop
buffer := utl_encode.base64_decode(utl_raw.cast_to_raw(dbms_lob.substr (p_clob, l_width, pos)));

dbms_lob.writeappend (res, utl_raw.length(buffer), buffer);

pos := pos + l_width;
end loop;

return res;

end clobbase642clob;



[RISC] said...

Hi Jason,
That's just what I was looking for! Thank you very much for the time and effort!
Best regards,