Creating PL/SQL Report
448173Jul 26 2005 — edited Dec 14 2005Hi
I have several reports written in plsql procedures which work fine provided I place them in a plsql region. I now have a need to run a long running report which branches to a page which displays a animated gif and runs the long running job (3 Minutes) which I have acheived.
What I want to do is return to the original page and display the results from the procedure ( I figure I could do this by changing the procedure to a function and return the results), what I would really like to know is how to have the procedure output the html (htp.p etc) for the tabs to keep a consistant web view or output the results from a pl/sql procedure to a particular region, at present it outputs to a blank page with the results but without the the tabs. A perfect solution would be to generate a popup window from a pl/sql procedure.
Just to explain the full process briefly of what I am trying to achieve.
1. A user selects from a select list what report they want to run (Working).
2. If the selected report is long running, display animated gif (Working).
3. Output the results consistant with the web interface (Tabs etc) ???,
If anyones knows of a easier/better method it would be greatly appreciated.
Thanks
Wayne