Re: Simple Trigger Question

Sybrand

Well I guess your fishing lesson worked becuase I was able to figure it out based on your original post.

I actually found out that my proposed solution did not work either becuase Oracle apparently considers NULL and ('') to be the same thing (which is actually "nothing"). I had to modifify it to the following: (NVL(:New.ImageUrl,'NULLVAL') <> NVL(:New.ImageUrl,'NULLVAL')

Any thanks for the help!
Lee

Sybrand Bakker <sybrandb_at_hccnet.nl> wrote in message news:<ghsfg05btc3lbvkq8pn79hg4cifdqin9u8_at_4ax.com>...
> On 28 Jul 2004 06:32:03 -0700, lduhl_at_corp.realcomp.com (Lee) wrote:
>
> >Sybrand
> >
> >My appolgies but I'm not sure if you are stating something or asking a
> >question.
> >
> >I assume you comment means that my check (:New.ImageUrl <>
> >:Old.ImageUrl) is not passing becuase the ":Old.ImageUrl" value is
> >null.
> >
> >If this is the case, do I solve this problem by using the "NVL"
> >function (IE: (NVL(:New.ImageUrl,'') <> NVL(:New.ImageUrl,''))?
>
> Lee,
>
> I was trying to learn you how to fish, I was trying to avoid fishing
> on your behalf.
> So, yes, this is the correct solution.
> Now if you would explain this to a coworker, who thinks NULL compared
> to NULL is TRUE. I'm struggling for several weeks now to try to
> explain this.
Received on Thu Jul 29 2004 - 09:31:25 CDT