- 论坛徽章:
- 0
|
本帖最后由 cenalulu 于 2012-11-30 13:36 编辑
在存储过程中定义条件中使用了in 条件,可是没有什么返回,
如下定义in条件不用变量是可以的。
DECLARE cur_fm CURSOR FOR select FISCAL_WEEK,OPERATION,SUM(PRIME_PASS)/SUM(PRIME_TESTED),SUM(TOTAL_PASS)/SUM(TOTAL_TESTED) from WEEKLY where BUILD_GROUP in ('NEW','MRW') group by FISCAL_WEEK,OPERATION;
但用上变量后就不行了。
v_LIST是变量,通过参数传入存储过程。写入log 值为:('NEW','MRW','COO')。
DECLARE cur_fm CURSOR FOR select FISCAL_WEEK,OPERATION,SUM(PRIME_PASS)/SUM(PRIME_TESTED),SUM(TOTAL_PASS)/SUM(TOTAL_TESTED) from WEEKLY where BUILD_GROUP in v_LIST group by FISCAL_WEEK,OPERATION;
|
|