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
|
- [PHP] Vienna anyone Alex Hogan
- André Cupini