stored procedure error
Posted: Fri Apr 20, 2007 10:21 am
hi, i have a code here and can't make it to work, im very new to stored procedure using mysql and i am not familiar yet
and the error message is
Code: Select all
DELIMITER $$
DROP PROCEDURE IF EXISTS `dorknozzle`.`InsertHelpDesk`$$
CREATE PROCEDURE `dorknozzle`.`InsertHelpDesk`(?EmployeeID int, ?StationNumber int, ?CategoryID int, ?SubjectID int. ?Description varchar, ?StatusID int)
BEGIN
insert into HelpDesk(EmployeeID, StationNumber, CategoryID, SubjectID, Description, StatusID)
values(?EmployeeID, ?StationNumber, ?CategoryID, S?ubjectID, ?Description, ?StatusID)
END$$
DELIMITER ;please help. thanks in advanceError 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 '?EmployeeID int, ?StationNumber int, ?CategoryID int, ?SubjectID int. ?Descripti' at line 1