Re: How to disable all database triggers??? Thanks

[Radu Virgil]

Add a condition in your triggers like:

if (DISABLE_TRIGER <> 1 ) then
#trigger body
end if;

and than if you want to disable triggers on import just:

SET @DISABLE_TRIGER = 1;

do imports

SET @DISABLE_TRIGER = 0;



Edited 1 time(s). Last edit at 12/08/2006 09:37AM by Radu Virgil.