|Subject||Re: [firebird-support] Stored Procedure Source Code limits on # of lines.|
|Author||Ann W. Harrison|
>Lucas Franzen wrote:
> 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).
> It's a limit of the size of the BLR (compiled code) not of the number ofActually there are two limits, one on the number of bytes in the
> You cannot increase this by any setting.
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.