Re: Simple timer question by a newbie
From: PG <realAddress_at_inmsg.com>
Date: 22 Jan 2002 17:37:49 GMT
Message-ID: <3C4DA41E.60001_at_inmsg.com>
>>Hi oracle gurus,
>>
>>i have a procedure that loads some data from a file and puts it in a
>>table. I would like to trigger this procedure repeatedly after a certain
>>duration. I want to use just oracle (no java/ c++/ vb etc). Is there a
>>standard timer in oracle? (some kind of sleep/ wait mechanism?)
>>
>>I am using Oracle 8.1.7.
>>
>>Thanks a lot in advance.
>>
>>PG
>>
>>
>
> Received on Tue Jan 22 2002 - 18:37:49 CET
Date: 22 Jan 2002 17:37:49 GMT
Message-ID: <3C4DA41E.60001_at_inmsg.com>
thanks. u rock :)
PG
Alistair wrote:
> Hi > > Check out the DBMS_JOB procedure, it does exactly as you want. You need to > check that job_queue_interval and job_queue_processes are set in your > init.ora file. > > Alistair > > "PG" <realAddress_at_inmsg.com> wrote in message > news:3C4D9ED6.50804_at_inmsg.com... >
>>Hi oracle gurus,
>>
>>i have a procedure that loads some data from a file and puts it in a
>>table. I would like to trigger this procedure repeatedly after a certain
>>duration. I want to use just oracle (no java/ c++/ vb etc). Is there a
>>standard timer in oracle? (some kind of sleep/ wait mechanism?)
>>
>>I am using Oracle 8.1.7.
>>
>>Thanks a lot in advance.
>>
>>PG
>>
>>
>
> Received on Tue Jan 22 2002 - 18:37:49 CET