Re: FORMS 5 Running stored procedures help

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 01 Oct 1998 21:04:53 GMT
Message-ID: <3613eab6.2439664_at_news.siol.net>


On Wed, 30 Sep 1998 11:41:01 GMT, mdesouza_at_YAHOO.COM wrote:

>hi all
>
>In my form I have got a button, which executes a when button pressed trigger
>The code of the trigger runs 5 stored procedure some which take 10 mins
>
>the probs is when this procedures are running my forms appears to be not
>responding if I look at the task manager .
>
>if I bring up another application and return to my form the screen goes all
>weird I cannot view my form until the procedure have finished and I get the
>message procedure completed
>
>I cannot give this form to the users as its stands cos its not very
>professional . Is there somethin I can do about it .
>
>If I do not touch the form its fine the cursor shows as busy and when the
>procedure have finished executing I get control back to my form
>
>Any help would be appreciated

If the work through the form interface is not dependant on the procedure execution progress/completion (in other words, if after pressing your <execute_procedure> button you want to continue working with the form eventhough invoked stored procedures are not completed yet), then consider calling your stored procedures through server's DBMS_JOB package.

Write a WHEN_BUTTON_PRESSED trigger that will call DBMS_JOB.SUBMIT procedure. In the WHAT parameter supply the stored procedure you want to execute, for the NEXT_DATE supply the SYSDATE (or maybe SYSDATE with some minimal delay) and for the INTERVAL supply 'NULL', so the job will be executed only once. With this technique the controll will be returned to your form immediately after you press the button and the procedures will be executed on the server totaly independant from the form.

>regards
>
>michael Dsouza

HTH,

--
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
================================================
The above opinions are mine and do not represent
any official standpoints of my employer
Received on Thu Oct 01 1998 - 23:04:53 CEST

Original text of this message