Subject Re: [firebird-support] Stored Procedure Source Code limits on # of lines.
Author Ann W. Harrison
> rbozzz schrieb:
>>Please help me with my stored procedure problem? I'm getting an error
>>message with my stored procedure that reached 1028 lines of code
>>(Including blank lines and comments).
Lucas Franzen wrote:

> It's a limit of the size of the BLR (compiled code) not of the number of
> lines.
> You cannot increase this by any setting.

Actually there are two limits, one on the number of bytes in the
procedure source, and one on the number of bytes in the compiled blr.
For the former, white space counts. Neither is a settable parameter -
both are the result of using a short where a long was more suitable.