存储过程中 条件判断问题

[liuhengwinner]

表
CREATE TABLE `srs_system_oilcanindetail` (
`vouchno` CHAR(12) COLLATE utf8_general_ci NOT NULL COMMENT '进油明细号',
`oilno` CHAR(8) COLLATE utf8_general_ci NOT NULL COMMENT '油品编号',
`oilcanno` INTEGER(11) NOT NULL COMMENT '油罐编号',
`teamvouchno` CHAR(10) COLLATE utf8_general_ci DEFAULT NULL COMMENT '班次流水'
)

在SQL窗口执行
select ingoodsdate,inafteliter,EmptyCubage,inaftefootage,WaterHeight,OilTemp,WaterBulk
from srs_system_oilcanindetail
where billstatus = '2' and oilcanno=2
order by ingoodsdate desc
limit 1;
正确返回一条记录

在存储过程中执行
select ingoodsdate,inafteliter,EmptyCubage,inaftefootage,WaterHeight,OilTemp,WaterBulk into @ingoodsdate,@inafteliter,@EmptyCubage,@inaftefootage,@WaterHeight,@OilTemp,@WaterBulk
from srs_system_oilcanindetail
where billstatus = '2' order by ingoodsdate desc
limit 1;
也正常返回一条记录， @inaftefootage,@WaterHeight,@OilTemp也赋值成功

在存储过程中执行
select ingoodsdate,inafteliter,EmptyCubage,inaftefootage,WaterHeight,OilTemp,WaterBulk into @ingoodsdate,@inafteliter,@EmptyCubage,@inaftefootage,@WaterHeight,@OilTemp,@WaterBulk
from srs_system_oilcanindetail
where billstatus = '2' and and oilcanno=2
order by ingoodsdate desc
limit 1;
这个查询返回值就是空了，为什么， 和第一条是同样的查询，在存储过程外是正常的啦

[liuhengwinner]

创表语句中省略了其它不相关的字段！

[liuhengwinner]

谢谢大家！谢谢大家！谢谢大家！

[zjcxc]

存储过程的脚本贴出来看看，是不是存储过程的参数名称和列表重复了