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.