CURSOR c_detail_score1 IS
select *
from (select t.detailid as detailid1, avg(t.summaryscore) as leader from t_dkh_eval_summary t) a FULL OUTER JOIN (select t.detailid as detailid2,avg(t.summaryscore) as firstleader from t_dkh_eval_summary t) b
on(a.detailid1 = b.detailid2) FULL OUTER JOIN (select t.detailid as detailid3, avg(t.summaryscore) as secondleader from t_dkh_eval_summary t) c
on(a.detailid1 = c.detailid3);写在存储过程里,
当 OPEN c_detail_score1; 的时候总是抛出异常, BEGIN
OPEN c_detail_score1;
EXCEPTION
WHEN OTHERS THEN
Result := -1;
END;
但是在PL/SQL里执行,完全正常,
减少一个full outer join 游标打开就没错,
到底是哪里出来问题,是游标哪里设置不对????还是我的SQL 写的有错误,请指教。
select *
from (select t.detailid as detailid1, avg(t.summaryscore) as leader from t_dkh_eval_summary t) a FULL OUTER JOIN (select t.detailid as detailid2,avg(t.summaryscore) as firstleader from t_dkh_eval_summary t) b
on(a.detailid1 = b.detailid2) FULL OUTER JOIN (select t.detailid as detailid3, avg(t.summaryscore) as secondleader from t_dkh_eval_summary t) c
on(a.detailid1 = c.detailid3);写在存储过程里,
当 OPEN c_detail_score1; 的时候总是抛出异常, BEGIN
OPEN c_detail_score1;
EXCEPTION
WHEN OTHERS THEN
Result := -1;
END;
但是在PL/SQL里执行,完全正常,
减少一个full outer join 游标打开就没错,
到底是哪里出来问题,是游标哪里设置不对????还是我的SQL 写的有错误,请指教。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货