Re: AFTER UPDATE trigger not working trying to specify WHEN

Thank you very much. If I read this correctly, a NULL value (or ' ') will be replaced with @ so the compare will test @ against VALUE if not null.

Thanks!

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<q4amqv8dtv9ual5nstc72gul2rctjnjheh_at_4ax.com>...
> On 6 Nov 2003 15:43:55 -0800, rojoni8_at_hotmail.com (Joe Saling) wrote:
>
> >Any suggestions are appreciated.
>
> Oracle doesn't distinguish between null and ''
> Both your when clause and your if statement don't take into account
> the column can be NULL. NULL is nothing, doesn't compare to anything,
> so the != clause fails. You'll need to work with nvl(<column>,'@') !=
> nvl(<column>,'@')
Received on Sun Nov 09 2003 - 20:34:24 CST