| Subject | Re: [firebird-support] Size of Stored Procedure | 
|---|---|
| Author | Thomas Steinmaurer | 
| Post date | 2011-11-30T11:45:47Z | 
Hello Michael,
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/
            > 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/