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: running a PL/SQL program in the background

Re: running a PL/SQL program in the background

From: Rod Corderey <Lane-Associates_at_csi.com>
Date: Thu, 16 Apr 1998 19:47:26 +0100
Message-ID: <3536523E.222CC6CB@csi.com>


gerhard,

also, inspired by a message from Jim curry further up this list, you could have a look at the DBMS_JOB database built-in available certainly from 7.2 onwards [ I can't put my hands on the 7.1 manual at the moment.]

cheers

Rod

Lane Associates
Lane_Associates_at_compuserve.com
http://www.Lane-Associates.com

Gerhard Moeller wrote:
>
> Hi,
>
> at the moment I program an admin tool for my project including context
> usable from webbrowsers. As some of the operations (e.g. optimize
> indexes) are rather lengthy in execution, I would like to start PL/SQL
> procedures in the background to give control instantely back to the
> user. (in other words: those functions should be not executed modal)
>
> The only idea I have at the moment is to create PL/SQL procedures on
> the fly (with dbms_sql.parse) ans submit them as a job, executed
> instantely.
>
> The problem with this sulution is that I have to get rid of the jobs
> and the procedures after execution. (There are just to many different
> procedures to let them exist all the time.) Of course, this could be
> done with some job that is executed regulary and checking what jobs
> are done and can be safely destroyed. But this is rather a bad hack
> than a clean solution.
>
> So... ...is there any other way to let PL/SQL procedures be executed
> in the background?
>
> Thanks for any hint, Gerhard.
>
> --
> Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE
> ICQ PIN: 2804938
> OFFIS | | | | | | Tel.: 0441/9722-122
> Escherweg 2 | | | | | | Sekr.: 0441/9722-113 oder -101
> D-26121 Oldenburg |O|F|F|I|S| Fax: 0441/9722-102
Received on Thu Apr 16 1998 - 13:47:26 CDT

Original text of this message

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