RE: Trigger problem...
- From: "Khedr, Waleed" <Waleed.Khedr@xxxxxxx>
- To: <SauerBL@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Sep 2004 18:09:06 -0400
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.
------------------------------------------------------------------------
------
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
