Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Execute stored procedure in the background from a Forms application.

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

From: Rich Vernick - UUNet <rvernick_at_notre.net>
Date: Wed, 12 May 1999 17:52:38 -0500
Message-ID: <7hct8i$lkj$1@ffx2nh3.news.uu.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US