Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: running a PL/SQL program in the background
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