Ichiro Kobayashi wrote:
Is it possible to place TRIGGER INACTIVATE at the beginning and place TRIGGER ACTIVATE at the end of STORED PROCEDURE?
Svein Erling Tysvær answers:
I think it would be better to make the stored procedure first update a field in a table and modify the trigger to check the value of that field.
Thomas Steinmaurer adds:
Similar, but another option would be to run the procedure with a different user and in the trigger to have something like:
... IF (CURRENT_USER <> '...') THEN BEGIN ... END
In Firebird 2.x, one could also use user-definable context variables with RDB$SET_CONTEXT, RDB$GET_CONTEXT, but the OP uses 1.5.