Hi All,
I have created the following stored procedure but not working as expected.....Some error line 3
DELIMITER $$
DROP PROCEDURE IF EXISTS mytest.sp_insert_request $$ CREATE [email protected] PROCEDURE sp_insert_request(@RequestID varchar(250) = null, @Status varchar(45)= null,@Status_message varchar(9180)= null,@time_of_post varchar(9180) = null,@time_of_start varchar(9180)= null,@time_of_completion varchar(9180)= null) BEGIN
INSERT INTO request ( RequestID, Status, Status_message, time_of_post, time_of_start,time_of_completion) VALUES ( @RequestID, @Status,@Status_message,@time_of_post,@time_of_start,@time_of_completion );
END $$
DELIMITER ;