messag length error

From: Date: Wed, 14 Jul 2004 15:03:40 +0000
Subject: messag length error
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-190483@lists.php.net to get a copy of this message
Hi folk's, (sorry my poor English) I'm working with a stored procedure. The procedure works fine. But when i execute the procedure in the php script, despiste also works, i get this warning: Warning: ibase_query(): message length error (encountered 0, expected 8) Anybody know why this warning? I'm searching in the net, but.. nothing at this time... * When i execute the procedure with "SELECT" instead "EXECUTE PROCEDURE" this don't work The source of procedure is this: ----------------- BEGIN SP CODE ------------------------------ BEGIN /* Verifica se o domínio já está cadastrado */ SELECT COUNTER_COUNT FROM COUNTER WHERE UPPER(COUNTER_DOMAIN) = UPPER(:COUNTER_DOMAIN) INTO COUNTER_RESULT; /* Domínio não cadastrado, insere e inicia o contador */ IF (:COUNTER_RESULT IS NULL) THEN BEGIN /* Contador */ COUNTER_RESULT = 1; /* Query */ INSERT INTO COUNTER ( COUNTER_DOMAIN, COUNTER_SINCE, COUNTER_COUNT ) VALUES ( :COUNTER_DOMAIN, CURRENT_TIMESTAMP, :COUNTER_RESULT ); /* Domínio já cadastrado, incrementa contador */ END ELSE BEGIN /* Contador */ COUNTER_RESULT = :COUNTER_RESULT+1; /* Query */ UPDATE COUNTER SET COUNTER_COUNT = (:COUNTER_RESULT) WHERE COUNTER_DOMAIN = :COUNTER_DOMAIN; END /* Retorna "COUNTER_RESULT" */ SUSPEND; END ----------------------- END SP CODE ----------------------------- Best Regards -------------------------------------------------------------------------------- André Cupini Programador andre@neobiz.com.br UIN# 149947291 Rua Prof. José Ranieri, 9-40 CEP 17012-260 Bauru/SP Fone/Fax: (14) 3234-6898 Rua Abílio Soares, 233 Cj 32 CEP 04005-000 Paraíso, São Paulo/SP Fone/Fax: (11) 3057-1883 -------------------------------------------------------------------------------- ... The Advertising Agency Song: When your client's hopping mad, Put his picture in the ad. If he still should prove refractory, Add a picture of his factory.

« previous php.general (#190483) next »