好的,
CURSOR aaa_cursor(p_ks_cd IN VARCHAR2, p_kj_dt IN VARCHAR2) IS
SELECT SUBSTR(a.FURIDEN_NO, 1, 1) AS denpyo_sbt_kbn
,g.gamen_id AS gamen_id
,a.ks_cd AS ks_cd
FROM ar_009_tr_sknzan_tk_msi b
,ar_009_tr_sknzan_tk_head a
WHERE
a.sknzan_tuke_id = b.sknzan_tuke_id
AND a.ks_cd = b.kaisha_cd
;现在的游标位置 cur_aaa aaa_cursor%ROWTYPE; FUNCTION main
(
p_kns_fd IN VARCHAR2
,p_kj_dt IN VARCHAR2
) RETURN NUMBER IS
预定在这里定义游标
begin
--------------
------------
..............
end main;
CURSOR aaa_cursor(p_ks_cd IN VARCHAR2, p_kj_dt IN VARCHAR2) IS
SELECT SUBSTR(a.FURIDEN_NO, 1, 1) AS denpyo_sbt_kbn
,g.gamen_id AS gamen_id
,a.ks_cd AS ks_cd
FROM ar_009_tr_sknzan_tk_msi b
,ar_009_tr_sknzan_tk_head a
WHERE
a.sknzan_tuke_id = b.sknzan_tuke_id
AND a.ks_cd = b.kaisha_cd
;现在的游标位置 cur_aaa aaa_cursor%ROWTYPE; FUNCTION main
(
p_kns_fd IN VARCHAR2
,p_kj_dt IN VARCHAR2
) RETURN NUMBER IS
预定在这里定义游标
begin
--------------
------------
..............
end main;
我在参数中使用了游标,而在main外边没有定义,是在main中定义游标的,
所以会出现“《PLS-00801》 内部错误[79110]”这个错误,解决方法:
在main外边定义一个游标,即使你没有使用它,也要定义,然后在main中定义游标,这样就不会出现这个错误了这个可能是plsql的一个bug,