AD (728x60)

Tecnologia do Blogger.

Followers

Total de visualizações

Archives

sexta-feira, 10 de janeiro de 2014

Procedure unknown GET_A02ACRE_CONFIG

Dynamic SQL Error SQL error code = -204
Procedure unknown 
GET_A02ACRE_CONFIG
At line 28, column 62


Execute a seguinte procedure no CTRL+ F12:
SET TERM ^ ;

CREATE OR ALTER PROCEDURE GET_A02ACRE_CONFIG (
    creemp integer,
    crecod integer)
returns (
    nomeconfig varchar(40),
    creempconf integer,
    creempemp integer,
    crcod integer,
    crnome varchar(40),
    crtaxa numeric(15,6),
    conciliacao varchar(40),
    crpzree integer)
as
declare variable xconfig integer;
BEGIN
    FOR SELECT
      A02ACRE.CRCOD,
      A02ACRE.CRNOME AS CONCILIACAO,
      A02ACRE_CONFIG.CRECONFCOD,
      A02ACRE_EMP_CONFIG.CREEMPEMP,
      COALESCE(A02ACRE_CONFIG.CRECONFNOME, COALESCE(A02ACRE.CRNOME, 0)) AS CRNOME,
      COALESCE(A02ACRE_CONFIG.CRECONFNOME, 'Não configurada na conciliação') NOMECONFIG,
      COALESCE(A02ACRE_EMP_CONFIG.CREEMPTAXA, COALESCE(A02ACRE.CRTAXA, 0)) AS CRTAXA,
      COALESCE(A02ACRE_EMP_CONFIG.CREEMPPZREE, COALESCE(A02ACRE.CRPZREE, 0)) AS CRPZREE
      FROM A02ACRE
      LEFT JOIN A02ACRE_CONFIG ON (A02ACRE_CONFIG.CRECONFCOD = A02ACRE.CRCONFIG)
      LEFT JOIN A02ACRE_EMP_CONFIG ON (A02ACRE_EMP_CONFIG.CREEMPCONF = A02ACRE_CONFIG.CRECONFCOD)
      WHERE ((A02ACRE_EMP_CONFIG.CREEMPEMP is null) or (A02ACRE_EMP_CONFIG.CREEMPEMP = :CREEMP)) AND A02ACRE.CRCOD = :CRECOD
      INTO :CRCOD, :CONCILIACAO, :CREEMPCONF, :CREEMPEMP, :CRNOME, :NOMECONFIG, :CRTAXA, :CRPZREE
    DO BEGIN
      SUSPEND;
    END
END^

SET TERM ; ^

/* Following GRANT statetements are generated automatically */

GRANT SELECT ON A02ACRE TO PROCEDURE GET_A02ACRE_CONFIG;
GRANT SELECT ON A02ACRE_CONFIG TO PROCEDURE GET_A02ACRE_CONFIG;
GRANT SELECT ON A02ACRE_EMP_CONFIG TO PROCEDURE GET_A02ACRE_CONFIG;

/* Existing privileges on this procedure */

GRANT EXECUTE ON PROCEDURE GET_A02ACRE_CONFIG TO ADMGER;
GRANT EXECUTE ON PROCEDURE GET_A02ACRE_CONFIG TO AFERICAO;
GRANT EXECUTE ON PROCEDURE GET_A02ACRE_CONFIG TO CHEFE;
GRANT EXECUTE ON PROCEDURE GET_A02ACRE_CONFIG TO EMIXZ;
GRANT EXECUTE ON PROCEDURE GET_A02ACRE_CONFIG TO LOJA;
GRANT EXECUTE ON PROCEDURE GET_A02ACRE_CONFIG TO MATEUS;
GRANT EXECUTE ON PROCEDURE GET_A02ACRE_CONFIG TO PISTA;
GRANT EXECUTE ON PROCEDURE GET_A02ACRE_CONFIG TO POSTOFT;
GRANT EXECUTE ON PROCEDURE GET_A02ACRE_CONFIG TO REPLICATOR;
GRANT EXECUTE ON PROCEDURE GET_A02ACRE_CONFIG TO SYSDBA;

Se o erro persistir, contate um facilitador.
Tags: , , ,

Postado por

Um novo sistema que auxilia técnicos da SoftPlus a executarem um trabalho mais rápido e fácil. Desenvolvido e alimentado pelos próprios técnicos.

0 comentários:

Postar um comentário

 

Mais Vistos

Adicionados Recentes

Copyright © SoftFácil | Desenvolvido por Rahel William