RE: Trigger problem...

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

Waleed

-----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.
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,=20
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

Other related posts: