RE: Trigger problem...

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Thu, 23 Sep 2004 18:09:06 -0400
Message-ID: <42BBD772AC30EA428B057864E203C9998AC4CB@MSGBOSCLF2WIN.DMN1.FMR.COM>

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_at_ldschurch.org]=20 Sent: Thursday, September 23, 2004 5:15 PM To: oracle-l_at_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,=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 Received on Thu Sep 23 2004 - 18:31:23 CDT