Hi folks, in our application we run a db job manually, by submitting a button. Job duration takes a while (1-2 minutes), and during this time an application "feels like frozen/running". To inform a user about that job is still running I have created a new simple dialog with text "In Progress", which I want to display before a job is submitted, and close once job is done. Unfortunately, an application still first "hangs" and once a database job is finished a dialog displayed. I tried to set a focus at the beginning, but no success. Any suggestions? Thanks, Tomas inProgressDialog
inProgressPanel
In progress package procedure:
|
Hi Tomas, Your code behaves exactly how it should. So there are no bugs or anything like that in Formspider. Here is the order of things happening and it's different than the order of things you assumed when writing the code above.
What you want to do should be possible in Formspider. I think here are the steps you need to follow: In procedure organizaceSyncHelios:
(*) The goal here is to run the job parallel so that Formspider can continue processing. I've never used the dbms_scheduler package but I think the code above achieves parallel execution. The code that the timer executes when it polls the server should check if the job is completed and hide the dialog when the job is finished and stop the timer as well. Hope this helps. Kind Regards, |