[RESOLVED] MySql - Error with stored

[Frehley]

Hi! Well, I have been fighting with this stored for quite a time... honestly I dont know whats the problem here. I checked it and re made it many times but nothing. Does any1 knows the problem?

Thanks!!

DELIMITER $$;

DROP PROCEDURE IF EXISTS `sistema`.`NuevoProducto`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `NuevoProducto`(IDProd int, Cod varchar, Descri varchar, Foto varchar, Rub int, SubRub int, FechaA date, IDUsu int, Empre int, Sucur int)
BEGIN
INSERT INTO Productos(IdProducto, Codigo, Descripcion, FotoPath, Rubro, SubRubro, FechaAlta, UserALTA, Empresa, Sucursal) Values (IDProd, Cod, Descri, Foto, Rub, SubRub, FechaA, IDUsu, Empre, Sucur);
END$$

DELIMITER ;$$

(0 row(s) affected)
(0 ms taken)

Error 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 ' Descri varchar, Foto varchar, Rub int, SubRub int, FechaA date, IDUsu int, Empr' at line 1
(0 ms taken)

[Frehley]

Solved::

DELIMITER $$;
 
DROP PROCEDURE IF EXISTS`NuevoProducto`$$
 
CREATE PROCEDURE `NuevoProducto`(
IN IDProd int,
IN Cod varchar(20),
IN Descri varchar(20),
IN Foto varchar(20),
IN Rub int,
IN SubRub int,
IN FechaA date,
IN IDUsu int,
IN Empre int,
IN Sucur int)
BEGIN
INSERT INTO Productos(IdProducto, Codigo, Descripcion, FotoPath, Rubro, SubRubro, FechaAlta, UserALTA, Empresa, Sucursal)
VALUES(IDProd, Cod, Descri, Foto, Rub, SubRub, FechaA, IDUsu, Empre, Sucur);
END$$
 
DELIMITER ;$$