--- In firebird-php@yahoogroups.com, "skotaylor" <scott@d...> wrote:

> --- 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.

Oef, don't let Helen read this...