From oracle-l-bounce@freelists.org Tue Mar 30 02:00:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2U808g23885 for ; Tue, 30 Mar 2004 02:00:08 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2U807o23878 for ; Tue, 30 Mar 2004 02:00:08 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5C856634A07; Tue, 30 Mar 2004 02:56:48 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26524-45; Tue, 30 Mar 2004 02:56:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AFEB46349A5; Tue, 30 Mar 2004 02:56:47 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 30 Mar 2004 02:55:37 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EA7DA634973 for ; Tue, 30 Mar 2004 02:55:36 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26387-30 for ; Tue, 30 Mar 2004 02:55:36 -0500 (EST) Received: from ha-smtp1.tiscali.nl (ha-smtp1.tiscali.nl [195.241.76.187]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8D448634992 for ; Tue, 30 Mar 2004 02:55:36 -0500 (EST) Received: from LEXLAPTOP (82-168-217-228-bbxl.xdsl.tiscali.nl [82.168.217.228]) by ha-smtp1.tiscali.nl (Postfix) with SMTP id E9AFE45022A for ; Tue, 30 Mar 2004 10:03:39 +0200 (CEST) From: "Lex de Haan" To: Subject: RE: Question about triggers Date: Tue, 30 Mar 2004 10:03:37 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 In-Reply-To: <184C07CA956B59418F925AACD4DF4CDEC71353@mail-server.iiv.scheidt-bachmann.de> Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2020 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lex.de.haan@naturaljoin.nl Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org aren't you better off with an instead-of trigger then? -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Foelz.Frank Sent: dinsdag 30 maart 2004 9:00 To: oracle-l@freelists.org 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@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 ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------