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
[EMAIL PROTECTED]
  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.

Reply via email to