Re: Newbie Question on trigger...

On Tue, 01 Oct 2002 10:52:32 -0400, smenard_at_avior.ca wrote:

>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!!!

You can grant update privilege on individual columns. Simply do not grant update privilege and you are set.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Oct 01 2002 - 12:04:55 CDT