problem description
when calling the stored procedure, 19 parameters were passed, but the program mistakenly reported 20 parameters
the environmental background of the problems and what methods you have tried
related codes
/ / Please paste the code text below (do not replace the code with pictures)
background API:
var sql = "CALL pro05_cropsSave";
var parameter = [organ_id, cm_name, alternate_name, cm_class, cm_type, cm_pic, crops_step_id, cm_cycle, environment, cultivation, lunar_date, sowing_date, sow_cycle, picking_date, pic_cycle, land_type, cm_describe, oper_user, remark];
mysql stored procedure: error message ER_SP_WRONG_NO_OF_ARGS: Incorrect number of arguments for PROCEDURE lgiot_agro_v20_test.pro05_cropsSave; expected 19, got 20
CREATE DEFINER= root @ localhost PROCEDURE pro05_cropsSave (IN p_organ_id > cm_name varchar (20), IN cm_name varchar (128), IN alternate_name varchar) IN lunar_date varchar (64), IN sowing_date date,IN sow_cycle int,IN picking_date > date,IN pic_cycle int,IN land_type varchar (1024), IN cm_describe varchar (1024), IN oper_user varchar)
what result do you expect? What is the error message actually seen?