create or replace
package body set_pass_rate_pkg as FUNCTION get_adjust_cur(p_adjust_cnt IN NUMBER)
RETURN v_get_adjust_cur is
v_get_adjust_cur v_get_adjust_cur;
begin
OPEN v_get_adjust_cur1 FOR
SELECT
CASE
WHEN wst.score -60 < 0 THEN
rank() over(PARTITION BY
CASE
WHEN wst.score -60 >= 0 THEN NULL
ELSE 'A'
END
ORDER BY wst.score)
END adjust_flag
FROM wl_student_tab ws,
wl_score_tab wst,
wl_course_tab wct
WHERE ws.student_id = wst.student_id
AND wst.course_id = wct.course_id
AND wst.score < 60;
return v_get_adjust_cur;
end get_adjust_cur;不报错 但是select set_pass_rate_pkg.get_adjust_cur(1) from dual;
前天可以调到 今天 就不行了 求助啊
package body set_pass_rate_pkg as FUNCTION get_adjust_cur(p_adjust_cnt IN NUMBER)
RETURN v_get_adjust_cur is
v_get_adjust_cur v_get_adjust_cur;
begin
OPEN v_get_adjust_cur1 FOR
SELECT
CASE
WHEN wst.score -60 < 0 THEN
rank() over(PARTITION BY
CASE
WHEN wst.score -60 >= 0 THEN NULL
ELSE 'A'
END
ORDER BY wst.score)
END adjust_flag
FROM wl_student_tab ws,
wl_score_tab wst,
wl_course_tab wct
WHERE ws.student_id = wst.student_id
AND wst.course_id = wct.course_id
AND wst.score < 60;
return v_get_adjust_cur;
end get_adjust_cur;不报错 但是select set_pass_rate_pkg.get_adjust_cur(1) from dual;
前天可以调到 今天 就不行了 求助啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货