我在 mysql中编写了一个存储过程来进行更新.当你在MySQL命令行中执行它时(通过MysqL编辑器),这工作正常.

存储过程是：

CREATE defineR=`root`@`localhost` PROCEDURE `Deduction_Of_PL`(
    IN P_EMPID VArchAR(1000)
)
BEgin
  DECLARE PresentYearPL VARCHAR(1000);

  set PresentYearPL=(select Present_Year_PL From leave_calculate_pl where employee_id=P_EMPID);

  IF(PresentYearPL<=0) THEN
    UPDATE leave_calculate_pl
    SET Carrie_PL=Carrie_PL-1
    where employee_id=P_EMPID;
  ELSE
    UPDATE leave_calculate_pl
    SET Present_Year_PL=Present_Year_PL-1
    where employee_id= P_EMPID;
  END IF;

END $$

我在PHP中调用相同的存储过程,我也传递输入参数.

$LeaveTyPEID_G=$this->getLeaveTypeid();
$query_G="CALL Deduction_Of_PL($LeaveTypeID_G)";

它给出了错误

UnkNown column 'parameter_value' in 'field list'  MysqL Error # :1054

请告诉我哪里出了问题,我该如何解决.