aren't you better off with an instead-of trigger then? -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Foelz.Frank Sent: dinsdag 30 maart 2004 9:00 To: oracle-l@xxxxxxxxxxxxx Subject: Question about triggers Hi gurus, Is it possible that a "...trigger before Insert on test for each row" trigger, throws away that Insert, without raising any application error ? Conditions : -It is not allowed, to let that specific data being inserted into that table (trigger watches and stores ist in a 2nd table) -the "forgetting" of the data should not raise ANY error Hints on that would be appreciated > Frank< ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------