>> Is that possible to place TRIGGER INACTIVATE at the beginning and
>> place TRIGGER ACTIVATE at the end of STORED PROCEDURE ?
>>
>> If that's impossible then how I could make it ?
>>
>>
>> PS : I use FB 1.5 on Win Server 2003
>
> 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.

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.


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!