Subject | Procedure body length |
---|---|
Author | Ricke_t |
Post date | 2005-09-26T12:18:10Z |
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
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