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-102