Trigger on several tables with time limit?

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 Thu Feb 20 2003 - 09:26:28 CST