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
tkyte_at_us.oracle.com (Thomas Kyte) wrote:
[...]
>>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
>
>Why do you have to get rid of them? If you submit a job in this fashion:
>
>
>declare
> l_job number;
>begin
> dbms_job.submit( l_job, 'some_procedure_to_run_once;' );
> commit;
>end;
>
>
>That will submit a job that runs once and will remove itself from the queue
>after it successfully completes (since NEXT_DATE wasn't set). That sounds like
>it is exactly what you want.
It removes the job from the queue? I didn't know that! (I thought the job will stay in the queue...) Great, that solves my problems indeed,
thank you very much, 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-102Received on Thu Apr 16 1998 - 10:38:47 CDT
![]() |
![]() |