In a nutshell, it is better to put your code
in a stored procedure outside of the trigger.
Why? Modular code is easier to reuse. You can't
reuse code blocks that are in a trigger. There are
other reasons, but this is the biggy IMO.
As Ferenc recommended, get the Feurstein book.
Jared
On
Read THIS fabulous manual:
http://www.bookpool.com/.x/pbsr99hds8/sm/0596003811
Ferenc Mantfeld
-Original Message-
From: [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L
Subject:DB Triggers vs