Re: Trigger problem...
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: SauerBL@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 23 Sep 2004 17:42:30 -0700
Are you checking for NULLs on both the sides? What if one has null value
and the other not null value?
On Thu, 23 Sep 2004 15:14:30 -0600, "Ben Sauer" <SauerBL@xxxxxxxxxxxxx>
said:
> 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,
> 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:
