Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Show "progress" of a process using pl/sql web toolkit?

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

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Tue, 31 May 2005 15:07:02 +0100
Message-ID: <MPG.1d067fdd42975bc5989e9a@news.individual.net>


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?

-- 

jeremy
Received on Tue May 31 2005 - 09:07:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US