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 Thu Feb 20 2003 - 09:43:30 CST
