Re: Newbie Question on trigger...

smenard_at_avior.ca wrote in message news:<20021001.105232.1139901474.14123_at_avior.ca>...
> It's there way in a trigger to compare all element in :new and :old with
> a loop or things like that :
>
> for i in :new
> loop
> if :new[1]!=:old[1] then
> raise_application_error('-20002','not good');
> end if;
> end loop;
>
> or i must compare one by one like that ...
> :new.nbr=:old.nbr
> :new.crap=:old.crap
>
> I need that in one of my table ... this table must be update in just one
> column (status) and my trigger must check that no others colums are update
> how i implement that short and sweet....
>
> Thanks you!!!

The row columns exist as distinct variables not as an array so you have to reference them individually.

HTH -- Mark D Powell -- Received on Tue Oct 01 2002 - 13:28:24 CDT