Hi,

At June 7, 2004, 01:15, J. P. Twarog wrote:

> Hi,


> I am trying to compile a stored procedure and get the following error:

> -request size limit exceeded

SQL>> Statement failed, SQLCODE = -901

> I am running Firebird 1.03 on RedHat 7.2:

> ISQL Version: LI-V1.0.3.972 Firebird 1.0.3
> Firebird/linux Intel (access method), version "LI-V6.2.972 Firebird 1.0.3"
> Firebird/linux Intel (remote server), version "LI-V6.2.972 Firebird
> 1.0.3/tcp (linuxdev)/P10"
> Firebird/linux Intel (remote interface), version "LI-V6.2.972 Firebird
> 1.0.3/tcp (linuxdev)/P10"


> If I had dynamic sql in v1.5 perhaps this would not be an issue....

What do you mean by dynamic SQL?

> However, it is odd that the procedure's dependencies
> (ping_a_particular_table ...) are each of a bigger filesize.

> Furthermore, if I comment either the first two "execute procedure" lines or
> the last two, it compiles...

> I suspect that filesize is not the issue.

> I am unable to find anything useful in the release notes or google...

> Does anyone have any suggestions?

I don't clearly recall how stored procedures are compiled, but it
almost seems as if the EXECUTE PROCEDURE commands are simply replaced
with the compiled version of the corresponding SP. And, if this is
truly the case, then the combined size of all the SPs might be bigger
than what can be handled. I don't remember if FB 1.5 has had changes
that affects that.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)