APEX

Hello all,

I'm looking to create a method allowing my apex users to request scheduled delivery of complex dashboard report pages to their email. I know that Interactive Reports allow for this, but I'm trying to capture an entire page of reports to send as a single email.

My thought is to write a pl/sql procedure to create an APEX session as the user, then use wwv_flow.show() to request the page and somehow capture the resulting HTML into a clob. I can then parse out the header and navigation panels and use the clob as the email body.

The trouble is, I cannot find any examples or ways to intercept the results of wwv_flow.show(). Has anybody done this? Does anybody have any ideas on how to proceed?


Thanks,
Matt