Re: Execute stored procedure in the background from a Forms application.

I have never implemented it but my theory goes....

When the user presses the button, use DBMS_JOB to execute the stored procedure. DBMS_JOB is a package which lets you submit jobs at a specified time. When the user presses the button, the job can be run, say, 10 seconds afterwards.
Return *should* pass back to your application and the job run in the background.

Let us know if you are successful.

Mark

vagelis Hristidis wrote in message <7h9fca$l2k$1_at_ulysses.noc.ntua.gr>...
>I have created a server-side stored procedure in my database, and it is
>executed when the user of my Forms builder application presses a button.
>This procedure needs about 5 minutes to execute. Is there a way to return
>immediately , so that the user can continue to use the application while
the
>procedure is executed on Oracle server?
>Thanks in advance.
>Please mail to me.
>
>Regards,
>Vagelis
>
>
>-----------
>Vagelis S. Hristidis
>Electrical and Computer Engineering
>National Technical University of Athens
>e-mail:exrist_at_cc.ece.ntua.gr
>URL:http://www.cc.ece.ntua.gr/~exrist
>
>
Received on Wed May 12 1999 - 07:46:03 CDT