Dynamic SQL Error SQL error code = -204Procedure 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.

Sped C490 - Bahia
Abastecimento Corrompido
Sintegra Reg54
Erros na versão 197
Erros na versão 198
XML em erros
Erro ao importar notas v197
List index out of bounds (3)
0 comentários:
Postar um comentário