Subject Re: Procedure body length
Author Ricke_t
Let me make it the question a little more clear.

What is the procedure body size limit?

--- In, "Ricke_t" <ricke_t@y...> wrote:
> Hello.
> My update script is blowing chuncks. If I remove some lines of code
> from the body, the script will run. If add them back I receive an
> error, "Single isql command exceeded maximum buffer size". I can
> compile the same procedure with all the code in EMS just fine.
> Interbase used to throw up an error when I compiled the procedure
> saying the procedure was to big. I would then move some code to a
> second procedure and everything was good as gold. My issue with
> firebird is that I can not tell when a procedure is too big.
> Does anyone know exactly how big the procedure body can be?
> Ricke