RE: Trigger problem...

  • From: "Khedr, Waleed" <Waleed.Khedr@xxxxxxx>
  • To: <SauerBL@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 23 Sep 2004 18:09:06 -0400

You can't test null values using (=3D, <>, etc).
You need to use ( is null, is not null, or NVL)


-----Original Message-----
From: Ben Sauer [mailto:SauerBL@xxxxxxxxxxxxx]=20
Sent: Thursday, September 23, 2004 5:15 PM
To: oracle-l@xxxxxxxxxxxxx
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.
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?
This message may contain confidential information, and is
intended only for the use of the individual(s) to whom it
is addressed.


Other related posts: