Ora-01086:保存点未建立或无效。
此SP抛出KRD_UPD_BORCTAHSILATYAP_SP错误。
当我在下面测试此循环时,出现错误:ora-01086
通常,它可以在不调用外部sp的情况下工作,我会用内联错误对其进行测试,然后回滚到保存点。我想念什么?
FOR rec IN (...records.....
)
LOOP
SAVEPOINT odemeIslemiBaslangic;
BEGIN
CASE rec.prosedur_ad
WHEN 'KRD' THEN
KRD_UPD_BORCTAHSILATYAP_SP(rec.musterino, rec.urundegeri, rec.taksitno, v_MuhasebeReferans, v_IslemReferans, v_Tarih);
IF v_MuhasebeReferans IS NOT NULL THEN
v_SonucKd := 10;
v_Aciklama := 'Başarılı işlem';
ELSE
v_SonucKd := 9;
v_Aciklama := 'Borç bulunamadı';
END IF;
END CASE;
cll_ins_tahsilatislem_sp(p_odemeno => rec.odemeno,
p_islemtarihi => v_Tarih,
p_musterino => rec.musterino,
p_urundeger => rec.urundegeri,
p_islemref => v_IslemReferans,
p_muhasebesubekd => rec.sube_kd,
p_muhaseberef => v_MuhasebeReferans,
p_aciklama => v_Aciklama,
p_sonuc => v_SonucKd,
p_kayityapan => v_KayitYapan,
p_kayittrxkod => v_KayitTrxKod);
UPDATE cll_gecikmisbankaalacak u
SET u.sonuc_kd = v_SonucKd
WHERE u.odemeno = rec.odemeno
AND u.kayit_drm = 'A';
EXCEPTION
WHEN OTHERS THEN
ROLLBACK TO SAVEPOINT odemeIslemiBaslangic;
v_SonucKd := 1;
v_Aciklama := 'İşlem Hata: ' || substr(SQLERRM, 1, 400);
cll_ins_tahsilatislem_sp(p_odemeno => rec.odemeno,
p_islemtarihi => v_Tarih,
p_musterino => rec.musterino,
p_urundeger => rec.urundegeri,
p_islemref => v_IslemReferans,
p_muhasebesubekd => rec.sube_kd,
p_muhaseberef => v_MuhasebeReferans,
p_aciklama => v_Aciklama,
p_sonuc => v_SonucKd,
p_kayityapan => v_KayitYapan,
p_kayittrxkod => v_KayitTrxKod);
UPDATE cll_gecikmisbankaalacak u
SET u.sonuc_kd = v_SonucKd
WHERE u.odemeno = rec.odemeno
AND u.kayit_drm = 'A';
END;
END LOOP;
最佳答案
您的评论表明您正在调用的过程KRD_UPD_BORCTAHSILATYAP_SP
正在回滚整个事务,即发出简单的ROLLBACK
。
从documentation for ROLLBACK
:
在没有ROLLBACK
子句的情况下使用TO SAVEPOINT
将执行以下操作:
结束交易
撤消当前事务中的所有更改
清除事务中的所有保存点
释放所有交易锁
因此,您在调用块中建立的保存点将被删除,因此您将无法回滚到该保存点。