From oracle-l-bounce@freelists.org Thu Sep 23 18:28:59 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8NNSxj01035 for ; Thu, 23 Sep 2004 18:28:59 -0500 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 i8NNSxI01029 for ; Thu, 23 Sep 2004 18:28:59 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CFCD972D772; Thu, 23 Sep 2004 17:53:51 -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 12052-99; Thu, 23 Sep 2004 17:53:51 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DF09272D677; Thu, 23 Sep 2004 17:45:18 -0500 (EST) Message-ID: From: Ken Naim To: "'SauerBL@ldschurch.org'" , oracle-l@freelists.org Subject: RE: Trigger problem... Date: Thu, 23 Sep 2004 18:16:24 -0400 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 10038 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ken@clubmom.com Precedence: normal Reply-To: ken@clubmom.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Most likely you are comparing something against a null if which case the result will come back false so the trigger will not fire. So it best to use an nvl around field or make the field not null with a default value if that is acceptable to your needs. When (nvl(new.col1,' ')<> nvl(new.col2,' ')) -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ben Sauer Sent: Thursday, September 23, 2004 5:15 PM To: oracle-l@freelists.org Subject: Trigger problem... Probably pretty basic... but I've got a trigger that needs to execute when the new VarChar2 field <> the old VarChar2 field. In other words on Change. But it seems that <> has strange results with them in the trigger. Am I supposed to use some alternate function like .equals() in Java. If so would somebody mind some syntax for me? Thanks, Ben ---------------------------------------------------------------------------- -- This message may contain confidential information, and is intended only for the use of the individual(s) to whom it is addressed. ---------------------------------------------------------------------------- -- -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l