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

DA Morgan wrote:

>

Exactly. That is what I used for our data warehouse loads. The web interface is HTMLDB - it simply does a longops query to get the current load's status (the process knows how many rows to load into the warehouse so longops stats are very accurate).

The operators thus have a very good idea just how far the current load has progressed.

But this has nothing really to do with dealing with a stateless web client - the exact same method would have been used for stateful clients too. It is always a bad idea to hourglass a client app for an extended period. Or have the client app own a long running server process. Much safer and better and sensible to have the client submit that as a background process instead.

--
Billy