RE: Question about triggers

  • From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 30 Mar 2004 10:03:37 +0200

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
-----------------------------------------------------------------

Other related posts: