Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating PL/SQL Report

448173Jul 26 2005 — edited Dec 14 2005
Hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2006
Added on Jul 26 2005
5 comments
910 views