FUNCTION mydatabase.sp_add_new_job_order does not exists

[Jassim Rahma]

I am getting this error: FUNCTION mydatabase.sp_add_new_job_order does not exists I checked on google and all were talking about spaces causing the problem but I am still unable to identify where is the problem. Kindly help.. here is my code:

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_add_new_job_order`(IN param_customer_id int, IN param_cleaner_id int, IN param_job_order_date date, IN param_start_time time, IN param_end_time time, IN param_job_order_note text, IN param_is_contract bit, IN param_contract_id int, IN param_total_hours decimal(11,6), IN param_created_user int, OUT param_record_identity int)
BEGIN
DECLARE param_job_order_id int;

INSERT INTO job\_orders (customer\_id, cleaner\_id, job\_order\_date, start\_time, end\_time, total\_hours, job\_order\_note, is\_contract, contract\_id, created\_date, created\_user) VALUES (param\_customer\_id, param\_cleaner\_id, param\_job\_order\_date, param\_start\_time, param\_end\_time, param\_total\_hours, param\_job\_order\_note, param\_is\_contract, param\_contract\_id, NOW(), param\_created\_user);
SET param\_job\_order\_id = LAST\_INSERT\_ID();
SET param\_record\_identity = param\_job\_order\_id;

UPDATE customers SET allow\_delete = FALSE WHERE customer\_id = param\_customer\_id;

IF (param\_is\_contract = TRUE) THEN
BEGIN
	UPDATE job\_orders SET job\_order\_status = 6 WHERE job\_order\_id = param\_job\_order\_id;
	UPDATE contracts SET remaining\_hours = remaining\_hours - param\_total\_hours WHERE contract\_id = param\_contract\_id;
END;
END IF;
-- add event log;
CALL sp\_add\_event\_log("JOBORDER", param\_job\_order\_id, param\_created\_user, "Job order was created.");
CALL sp\_add\_event\_log("CUSTOMER", param\_customer\_id, param\_created\_user, "Job order was created.");

END

Technology News @ www.JassimRahma.com