Re: How to use timers

From: C. Ferguson <c_ferguson_at_rationalconcepts.com>
Date: Mon, 16 Aug 1999 19:07:17 -0700
Message-ID: <37B8C3D5.E0CF765E@rationalconcepts.com>

Hi Kamel,
look into dbms_job, a scheduled job. Create a stored procedure that will do the work of cleaning up the table, and use dbms_job to schedule it to run daily.

Good Luck,
Cindy

Kamel Hamard wrote:

> Hi,
>
> I want to program the following application under Oracle:
>
> I have records which are inserted in a table A. Each inserted record has a
> insertion date.
> The table records A is visited every 24 houres and the records which are in
> the table for more 24 houres are deleted from the table A.
>
> Is it possible implement this mecanism only based on oracle ressource for
> example using timers and triggers?
>
> Thanks for any idea to do it.
>
> PS: I dont want to use a external program to pool the table A every 24
> houres to remove the records.
>
> Kamel.
Received on Mon Aug 16 1999 - 21:07:17 CDT