Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Triggers on multiple similar tables

Re: Triggers on multiple similar tables

From: John P. Higgins <jh33378_at_deere.com>
Date: 1997/01/25
Message-ID: <32E9582E.740B@deere.com>#1/1

jshiruru_at_att.com wrote:
>
> Hi all,
>
> Thanks to all those who replied to my earllier queries. My next question
> is somewhat strange.
> I have two tables 'table1' and 'table2' whose fields are exact mirror
> images of each other(don't ask me why). The data might be different, but
> the fields are same. A trigger must fire when any updates/insert are
> done on these tables. Is it possible to have only one trigger for these
> two tables. The Application Developer's guide says 'NO'. But is there a
> workaround solution where only one trigger is required for two similar
> tables ? I know I am asking for too much here. But it's just a shot.
>
> Thanks a lot for any help
>
> Jagdeep
> jshiruru_at_att.com
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
It takes a trigger per table. But, each trigger can call a single stored procedure!

-- 
John P. Higgins      Voice:    (309)765-4481
Deere & Company      Fax:      (309)765-5168
John Deere Road      Internet: jh33378_at_deere.com
Moline, IL 61265     Opinions: My Own
Received on Sat Jan 25 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US