Should be a grant problem..
also
Same statements are there in Inserting & Updating.. U can write as
If inserting or updating
.
. Statements......
.
End if;
Or
U can omit that if statement(In this case), bcoz, trigger definition itself contains the same.




Reply With Quote