You want to use DBMS_JOB.SUBMIT. Default parameters specify immediate
execution, but you can override it.
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 - 17:52:38 CDT
