Why my procedure is not being accepted, I am using mysql6.3

Navigation
1
create procedure cadastrar_nadador (out nome_v varchar(80),out sexo_v varchar(1),out nascimento_v date,out patrocinio_v varchar(80))
    begin
        insert into nadador(nome,sexo,nascimento,patrocinio)
        values (nome_v,sexo_v,nascimento_v,patrocinio_v); 
    end;
    
asked by anonymous 18.11.2017 / 21:53

1 answer

0

Hello try to use the following syntax as the basis for your procedure: 

DELIMITER $$
CREATE PROCEDURE nome_procedimento ()
BEGIN
    /*CORPO DO PROCEDIMENTO*/
END $$
DELIMITER ;

Well, it seems like a syntax error indeed.

    
08.04.2018 / 18:44
Use certificates in the Azure web application after the Brazilian Root intermediate chain v5 has been updated to authorize NFe Problem Hibernate 4.3 with Glassfish 3.1