Because my project is not being accepted, I am using mysql6.3

Asked

Viewed 22 times

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;
mysql sql stored-procedures procedure

  • ideal would be to show the error and the table structure.

  • 1

    Put the Error and your table structure here. People vote negative but don’t want to comment here p/ help ..

1 answer

0

Hello tries to use the following syntax as a basis for your process:

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

'Cause it seems like a syntax error to me.

Browser other questions tagged mysql sql stored-procedures procedure

You are not signed in. Login or sign up in order to post.