select c.COMPUTER_DATE,c.year into computerDate,myear from COMPUTER c where c.employee_no = employeeNo and GET_MINUS_MONTH(iyear,imonth,COMPUTER_DATE) < 36 and ((c.year = iyear and imonth>=c.month) or (iyear>c.year));
传入的变量开始我用到额不是iyear,而是year,这样导致的问题是c.year=year中的第二个year会被当成字段,而非传入的变量