Single isql command exceeded maximum buffer size

I have quite a long trigger and when I use it within an script launched 
with isql on linux, it gives the following error:
"""
Single isql command exceeded maximum buffer size
"""

Reducing the lenght of the trigger solves it, but I was wondering if 
there's nay way to increase this buffer size.

My ib is version 7.5. I checked and this doesn't happens on windows, 

> I have quite a long trigger and when I use it within an script launched 
> with isql on linux, it gives the following error:
> """
> Single isql command exceeded maximum buffer size
> """
> 
> Reducing the lenght of the trigger solves it, but I was wondering if 
> there's nay way to increase this buffer size.

Either you hit the max SQL statement length of ~64Kb or a BLR limit, 
which I can't remember exactly but probably about ~48Kb.

You have to split up the trigger into multiple triggers. The nice thing 
about the trigger implementation in InterBase is that you can have 
multiple triggers on the same table/operation/event.




-- 
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions