Re: Trigger on several tables with time limit?

Well, one reason I need this kind of features is alarm management.

Let say some application writes alarms to the database. I would like to react to the fact that a alarm has been turned on and not turned off within a certain time limit, say three minutes.

I really don't want to poll the databas all the time, hard to know how often to poll it to begin with.

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.com> wrote in message news:<CI65a.189869$be.178124_at_rwcrnsc53>...
> Never heard of it, don't know why you want it, but use dbms_job to do it for
> you. Have an ordinary trigger create a dbms_job that will populate the 2nd
> table x amount of time in the future.
> Jim
> "M" <marvelan_at_hotmail.com> wrote in message
> news:c0abefc3.0302200726.59816251_at_posting.google.com...
> > I thought of building a kind of super/multi trigger for Oracle and
> > would like to get an second oppinion if it is a good idea. Or if
> > there already exists good solutions for this...
> >
> >
> > What I thought of doing is to build a stand alone server that can
> > be used to define triggers on several tables. Lets say I want to
> > trigger when:
> >
> > "(table1.value1 > 12) and (table2.value2 < table4.value4)"
> >
> > Not neccesarily using this made up syntax, or some other
> > combination of changes in several tables.
> >
> > I also would like to have some kind of temporal capability, for
> > example I would like to trigger on:
> >
> > "table1.value1 < 12 and (table2.value1 < 12 within one hour)"
> >
> > I also would like the changes in the table to be able to be apart
> > from each other in time. So that first I wait for a change in one
> > table and then, few hours later, a change in other table will
> > trigger my super-trigger (or whatever it should be called)
> >
> > Am I inventing a wheel here? I have the need for this capability?
> > What about you?
> >
> > Cheers
> > /Marv
Received on Fri Feb 21 2003 - 02:10:55 CST