Re: Protect record from deletion via trigger

hpuxrac wrote:

> Tom Kyte says ( and I believe him ) "Triggers are evil" ... therefore
> don't use them at all or at least minimize their usage.

If you are going to quote Tom, and he did say it, then quote him in context:

Responding to the statement:
"Protecting data integrity is paramount,"

Tom wrote:
"indeed it is, that is why triggers are evil :)

Most of the time, "business logic"/"data logic" that is implemented in triggers is done incorrectly (that is what I mean by people abuse triggers)."

http://tkyte.blogspot.com/2006/09/classic-example-of-why-i-despise.html

It is not the triggers that are the issue ... it is poor implementations with triggers. There is a time and place for triggers. And when used correctly they can be the best solution possible.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org