1
I have the following Trigger generated in my database:
SET TERM ^ ;
CREATE OR ALTER TRIGGER ATUALIZA_CODNCM FOR EST_ADICIONAIS
ACTIVE BEFORE INSERT OR UPDATE POSITION 0
AS
begin
UPDATE est_adicionais
set id_ncm = (select ncm.id from est_adicionais inner join ncm on
(est_adicionais.ncm = ncm.numero)
where est_adicionais.ncm = new.ncm and est_adicionais.codigo = new.codigo)
where codigo = new.codigo;
end
^
SET TERM ; ^
Only when executing the command below has the following output:
update est_adicionais e set e.st = '010' WHERE e.codigo = 135;
Exit:
Invalid token.
invalid request BLR at offset 258.
function HASHMD5 is not defined.
module name or entrypoint could not be found.
When running separately the Select and Update 2 commands are executed without any problem.
You have the UDF HASHMD5 in your BD?
– wesley luan
@wesleyluan believe I should not have? This comes native or you need to add separately?
– DevAgil
Is there a Rigger that is using this UDF ?
– wesley luan
How do I identify the use of this UDF?
– DevAgil