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.
Subscribe to:
Post Comments (Atom)
4 comments:
Very nice! Well done Jason.
Dimitri
Hi Jason,
Any change you could add a clobbase642clob function to your package? Best regards,
Georger
Georger:
Would the following function work for you?
function clobbase642clob (
p_clob in clob ) return clob
is
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;
begin
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;
Regards,
Jason
Hi Jason,
That's just what I was looking for! Thank you very much for the time and effort!
Best regards,
Georger
Post a Comment