PROBLEME PROCEDURE STOCKEE
SLT
j ai un messsage d' error quand j essaie de creer une procedure stockee
voici message error
MySQL a répondu:
#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 'integer' at line 11
Create Procedure AddChauffeur(in nom varchar(30), in pNom varchar(30), in numNat int,
in rue varchar(30), in numRue varchar(5), in cp integer,
in ville varchar(30), in tel varchar(13), in gsm varchar(14),
in mail varchar(30), in datNais Date, in nbPersChrg integer,
in sx varchar(15), in etCiv varchar(15),
in stat varchar(20), in dtDeb Date, in dtFin Date)
BEGIN
declare idkey integer;
INSERT INTO tchauffeurs(nomChauf,
pNomChauf,
numNatChauf,
rueChauf,
numRueChauf,
cpChauf,
villeChauf,
telChauf,
gsmChauf,
mailChauf,
dtNaisChauf,
nbPersChargeChauf,
sexe,
etatCiv)
VALUES (nom,pNom,numNat, rue, numRue, cp,ville,tel,gsm,mail,datNais,nbPersChrg,sx,etCiv,);
SELECT idChauf into idKey FROM tchauffeurs WHERE numNatChauf= numNat;
INSERT INTO tcontrats(statutCont, dtDebCont, dtFinCont)
VANUES(stat, dtDeb, dtFin);
END;
merci
