Erro na Trigger
Estou criando esta trigger e está me dando o erro de: O que devo fazer?
Erro:
SQL Error code = -104
Unexpected end of command
SQL:
/* Trigger TarFaiCon - BEFORE UPDATE */
CREATE TRIGGER TarFaiCon_BU FOR TarFaiCon
BEFORE UPDATE AS
DECLARE VARIABLE vConsumo INTEGER;
BEGIN
NEW.ConIni = 0;
EXECUTE PROCEDURE FAICONINI( NEW.TipCat, NEW.Ano, NEW.Mes, NEW.ConFin ) RETURNING_VALUES :vConsumo;
NEW.ConIni = vConsumo;
END @
Erro:
SQL Error code = -104
Unexpected end of command
SQL:
/* Trigger TarFaiCon - BEFORE UPDATE */
CREATE TRIGGER TarFaiCon_BU FOR TarFaiCon
BEFORE UPDATE AS
DECLARE VARIABLE vConsumo INTEGER;
BEGIN
NEW.ConIni = 0;
EXECUTE PROCEDURE FAICONINI( NEW.TipCat, NEW.Ano, NEW.Mes, NEW.ConFin ) RETURNING_VALUES :vConsumo;
NEW.ConIni = vConsumo;
END @
Havilux
Curtidas 0