RE: Trigger problem...

  • From: Ken Naim <ken@xxxxxxxxxxx>
  • To: "'SauerBL@xxxxxxxxxxxxx'" <SauerBL@xxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 23 Sep 2004 18:16:24 -0400

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Ben Sauer
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
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
use some alternate function like .equals() in Java.  If so would somebody
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: