Re: Show "progress" of a process using pl/sql web toolkit?

"Jeremy" <newspostings_at_hazelweb.co.uk> wrote in message news:MPG.1d06346eab4a9454989e98_at_news.individual.net...
>
> Platform: Oracle 9iR2 on Sun Solaris 9 with Oracle HTTP Server and
> mod_plsql
>
>
> We have made extensive use of the PL/SQL web toolkit (htp etc packages).
> Sometimes submitting a form may result in an update that takes some
> time. We would ideally like to be able to show the user some kind of
> progress indicator but I cannot work out if how this can be done - has
> anyone come up with any cunning solutions?
>
> I am thinking of a "refresh" set say to 5 seconds and which could show
> the progress of the task... the problem of course is communicating that
> progress. Assume the user has pressed the submit button and we have
> commenced execution of the pl/sql procedure named in the <form> tag.
> This may know for example that it has 500 transactions to perform and it
> can obviously therefore determine how far it is through the process of
> those... but how can it communicate this progress to the user in real
> time?

1. You can register and start a job in background oracle process and return job ID to the browser.
2. Browser will periodically request state of or send message to that job by its ID (Job have to update its state and check for the messages from the browser, if any)
3. Job have to remove its regisration when completed

Learn about following oracle PL/SQL supplied packages:  DBMS_JOB (job creation and submission)
 DBMS_PIPE, DBMS_ALERT (interaction between different oracle sessions - send/receive messages and notifications) or DBMS_APPLICATION_INFO

>
> Thanks for any suggestions.
>
>
>
>
>
> --
>
> jeremy
> '02 Fazer 600 in blue
> _______________________________________
> jeremy at hireserve dot com
>
Received on Tue May 31 2005 - 08:59:31 CDT