RE: Database triggers question

From: Robson, Peter <pgro_at_bgs.ac.uk>
Date: Wed, 12 Jun 2002 01:28:20 -0800
Message-ID: <F001.0047B860.20020612012820@fatcity.com>

> -----Original Message-----
> From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com]
> Sent: 11 June 2002 19:51
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Database triggers question
>
>
> Testing is a taboo ...
>
> Well, they do the testing, but it is never enough. Usually a
> release is
> followed by 2/3 emergency fixes for a real developer anyway.
> (before anyone
> jumps on this statement let me say is loudly that I have been
> a developer
> for past 7 years and just joined the dark side.)
>
> My problem is, " is it a good idea to have large triggers or
> package the
> code and call it from triggers" ? Can someone throw a light on this?

At face value, your latter option appears to be the one which would allow code sharing. I would tend to that. Your specific circumstances may dictate other issues, of course.

peter
edinburgh

>
> Raj
> ______________________________________________________
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect
> that of ESPN Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art!
>
>
> -----Original Message-----
> Sent: Tuesday, June 11, 2002 1:27 PM
> To: ORACLE-L_at_fatcity.com
> Cc: Rajendra.Jamadagni_at_espn.com
>
>
> Hmmm.... Sounds like you have some real duhvelopers there.
>
> Unit testing of code is much easier when it's outside of a trigger.
>
> But the folks you're working with may not do unit testing.
>
> Is it possible? ;)
>
> Jared
>
>

---

This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please

scan all attachments.                            http://www.bgs.ac.uk
*********************************************************************

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robson, Peter
  INET: pgro_at_bgs.ac.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jun 12 2002 - 04:28:20 CDT