MySQL Forums
Forum List  »  Stored Procedures

#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 '' at line 38
Posted by: Suresh Ramachandran
Date: July 09, 2014 04:56AM

I am unable to create the procedure it is giving me this error

#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 '' at line 38


DROP PROCEDURE IF EXISTS `patient_appointment_values`;

CREATE PROCEDURE `patient_appointment_values`
(
IN p_appointment_id int(11),
IN p_doctor_id int(11),
IN p_ref_doctor_id int(11),
IN p_ref_doctor_sep varchar(50),
IN p_user_id int(11),
IN p_time datetime,
IN p_subject varchar(255),
IN p_message text,
IN p_created_date timestamp
)
BEGIN

INSERT INTO `appoinments_table`
(
`appointment_id`,
`doctor_id`,
`ref_doctor_id`,
`ref_doctor_sep`,
`user_id`,
`time`,
`subject`,
`message`,
`created_date`
)
VALUES
(
p_appointment_id,
p_doctor_id,
p_ref_doctor_id,
p_ref_doctor_sep,
p_user_id,
p_time,
p_subject,
p_message,
p_created_date
) ;
END

Can Anyone help me out in this regard.

Regards,
R. Suresh

Options: ReplyQuote


Subject
Views
Written By
Posted
#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 '' at line 38
2841
July 09, 2014 04:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.