BEGIN
call buscaativo(new.macptqa_idmacptqa,@$ativo);
if @$ativo=0 then
SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Placa inativa';
    END IF;
END

BEGIN
select ativo into $ativo from macptqa
where idmacptqa=$idmac;
END

inn $idmac
out $ativo