Re: Multiple Triggers of Same Type on Same Table?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 30 May 2006 06:59:20 -0700
Message-ID: <1148997560.220040.183720@r44g2000cwb.googlegroups.com>

Yes, where you have an environment with multiple applications (or sub-applications) a before insert trigger specific to the processing needs of each might be created on one table. Having separate triggers can aid in locating code that has to be checked and maintained for future changes.

The order in which the triggers fire should not matter. If you have logic that needs to process in a certain order then you should probably have only one trigger since the target of the trigger logic would probably be the same.

HTH -- Mark D Powell -- Received on Tue May 30 2006 - 08:59:20 CDT