T
TheMadDBA
Guest
I agree that some people misuse triggers and put way too much business logic into the triggers. This happens much less often in Oracle because the triggers can't just be overridden at the session level. It is either enabled or disabled for everyone. There are still valid uses of table and field level triggers that you just want to happen all of the time no matter who is doing the update and how they are connected to the database. You can make the argument that a properly designed application with data layers would do the same thing.... but you and I know that the vast majority of applications (especially written in Progress) do not fit that mold.
Continue reading...
Continue reading...