messag length error
| From: | André Cupini | 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.