Hi,
I'm using APEX 4.1 and wanted to find out how to pickup and use htp.prn output. Currently I have a PL/SQL region on my page which is calling a packaged pl/sql function which is htp.prn the content out from within the function itself so not in the region source.
I'm hoping to dynamically refresh this report using Dynamic Actions and AJAX. My page has a button called Refresh and it triggers a dynamic action. The Dynamic Action at this moment only has one action (Execute Pl/sql code). In firebug when I inspect the the ajax request I can see the server responding with htp.p content. Now I was wondering how do I pick up that value using a an Action? I was wondering whether it had to be like a P0 page item which I populated and then used jQuery to read its value and inject the content into my page.
Any Ideas?
I suppose I could write an ajax function that calls an Application On-demand process but wondered how others did this using Dynamic actions