--- In firebird-php@yahoogroups.com, "constantijnw" <cwfs@x> wrote:

> Hello,
>
>
> I'm using Apache 2.0.49 OpenSSL 0.9.7d / PHP 4.3.5 / Fb 1.5 on W2K.
>
> I have the following procedure:
>
> ALTER PROCEDURE "USERSESSION_START"
> (
> "ACCOUNTNAME" VARCHAR(32) CHARACTER SET UNICODE_FSS,
> "USERNAME" VARCHAR(32) CHARACTER SET UNICODE_FSS,
> "PASSWRD" VARCHAR(32) CHARACTER SET UNICODE_FSS,
> "CLIENTADDRESS" VARCHAR(21) CHARACTER SET UNICODE_FSS
> )
> RETURNS
> (
> "ACCOUNTID" INTEGER
> )
> AS
> BEGIN
> /* Just for the purpose of this question 1 simple expression */
> ACCOUNTID = 1004;
> END
>
> When I execute this procedure as a executable procedure i get the
> message:
>
> Warning: ibase_execute(): message length error (encountered 0,
> expected 8)in C:\wwws\LoginMan.php on line 69
>
> When i add a suspend and execute the procedure as selectable
> procedure then the correct value is returned.
>
> Any advice on this?

Put the suspend back in. One is needed if you want the SP to return
any values.