Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Question about triggers

Question about triggers

From: Foelz.Frank <Foelz.Frank_at_Scheidt-Bachmann.de>
Date: Tue, 30 Mar 2004 10:00:15 +0200
Message-ID: <184C07CA956B59418F925AACD4DF4CDEC71353@mail-server.iiv.scheidt-bachmann.de>


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_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Mar 30 2004 - 01:56:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US