Oracle Database Discussions

On several Oracle forums, I've seen several people take a strong position on avoiding the use of TRIGGERs for business rules. Could we start a thread on why people are for/against them (unless someone has a link to one that's already exhausted this topic).

I've been pushing the use of TRIGGERs for business rules, so that we don't have to code the equivalent in any of our multiple interfaces (desktop and web), as well as having the business rules remain intact if we're changing the data via TOAD. We also put an "escape" at the top of each trigger as well, where a PACKAGE spec variable is tested for a particular value, allowing the the remainder of the TRIGGER code to be aborted if necessary. That way, we can avoid the overhead of processing the TRIGGER code for jobs which we know won't violate the business rules.

--=cf