Okay. Then the dbms_job package in the trigger should do it. You can have
the job run at some future time eg 40 minutes.
Jim
"M" <marvelan_at_hotmail.com> wrote in message
news:c0abefc3.0302210010.1276c901_at_posting.google.com...
> 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 - 09:36:55 CST
