Steve,

> begin
> execute statement 'alter trigger ' || :trig || ' inactive' ;
> suspend;
> end

Start with removing the SUSPENDs. The block doesn't return anything to the caller, so there is no need for SUSPEND. Worse, after SUSPEND the caller is supposed to fetch the data - but that won't happen because there are no output columns.

Probably, only the first trigger is set to inactive. Does the block run to completion at all? Do you get any error messages?

I didn't look at the rest of the code thoroughly, but I'd say: try it without the SUSPENDs first and see what happens then.


Kind regards,
Paul Vinkenoog