delimiter $$
create procedure reposta(out mensagem varchar(100))
begin
if new.codigo_veiculo != null then
set mensagem = "Algum veículo está sendo utilizado";
end $$
delimiter ;
error that appears
Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5