Re: Searching for "the mother of all triggers"...

From: Nitin Dahiya <ndahiya_at_hotmail.com>
Date: Fri, 23 Jul 1999 20:32:52 +0200
Message-ID: <7nc6t8$abj$3@pumba.class.udg.mx>

you could create a dynamic sql procedure (check from the oracle documentation)
and get all triggers to call this procedure with the table/column name as the parameters.

regards,
nitin.

Holger Schümann <Schuemann.Holger_at_vertrieb.guj.de> wrote in message news:932727371.69845_at_news.mediaWays.net...
> Hi,
>
> I'm searching for a way to execute the same code for updates on different
> tables. Is there a way to do this without generating triggers for all the
> tables? What I think of is a "shema-trigger" wich would give me the name
of
> the updated table and column(s) and the row(s).
>
> Thank you in advance.
>
> Regards,
> Holger Schümann
>
>
>
Received on Fri Jul 23 1999 - 13:32:52 CDT