Re: "We don't do triggers"

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 21 Nov 2003 16:39:28 -0800
Message-ID: <1069461593.469273@yasure>

(Pete Cresswell) wrote:

> RE/
>

>>some take this stand for portability -- stored procedures must be written,
>>at least partially, in a proprietary language that is not portable across
>>databases
>>
>>so what's the target deployment environment(s)?

>
>
> This app has more stored procedures than Carter has liver pills. My take would
> be that eliminating triggers hasn't reduced the numbe of SPs by more than a few
> percent.

More bad design layered on top of bad design. An Oracle database with more than a handful of procedures should have no procedures: It should have packages.

Under the conditions you describe I'd quickly conclude that the architect doesn't understand the architecture.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Nov 21 2003 - 18:39:28 CST