Re: Database Triggers

Set up a package variable (probably a boolean). Something like (syntax might not be exactly correct): create or replace package mypkg is
doing_batch_update boolean;
end;
/

Then, in your batch update:
mypkg.doing_batch_update := True;

Then, in your trigger:
If mypkg.doing_batch_update = FALSE or mypkg.doing_batch_update is null THEN
--- do trigger stuff
end if;

>
Received on Mon Jan 14 2002 - 14:59:13 CST