Subject Re: [firebird-support] Size of Stored Procedure
Author Thomas Steinmaurer
Hello Michael,

> I just need a confirmation that the size of the text written to a stored procedure is limited to 65K.

It's bound to the limit of ~64K for the maximum SQL statement length in
case of your CREATE PROCEDURE statement and there is another limit on
the maximum length of compiled BLR code, which is AFAIK ~ 48K.

HTH.


--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/