Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Show "progress" of a process using pl/sql web toolkit?
In article <d7hqia$11lu$1_at_news.caravan.ru>, Dmitry E. Loginov says...
> 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
>
I suppose then this would have to be actually a pop-up status window...?
And the pl/sql package behind that pop-up window would be reading the PIPE getting status information written from the pl/sql package running behind the main browser window?
If that's the case then I follow your logic... just then a case of (I guess?) a little javascript code somewhere to close the popup window once the processing is complete?
-- jeremyReceived on Tue May 31 2005 - 09:07:02 CDT