Re: Timer and Oracle 8.0.4

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Wed, 5 May 1999 09:22:36 +0100
Message-ID: <7gorn8$2im$1@news.inet.tele.dk>

Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk> wrote in message news:3728E415.FDE3038E_at_rdbms.freeserve.co.uk...
> Evert,
>
> Sounds like something that could be done via Oracle Advanced Queues
> (AQ).
>
> Chris.
>
> "Evert J. Smit" wrote:
> >
> > When i've inserted a record in a specific tables I want to start a timer
> > that updates the record for example after an hour.
> >
> > Is this possible in Oracle 8.0.4.x
> >
> > If so I've no idea how to do this. Could anybody help me please.
> >
> > Thanks,
> > Evert
>
>

You could also create a job with DBMS_JOB to be run in an hours time. Take a look at DBMS_JOB, it's quite OK for scheduling jobs (stored procedures).

HTH. Finn Received on Wed May 05 1999 - 03:22:36 CDT