Re: AFTER UPDATE trigger not working trying to specify WHEN

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>,'@')

--
Sybrand Bakker, Senior Oracle DBA