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/