Ada yang tau bagaimana caranya saya meneruskan loop di PL/SQL walaupun
terjadi exception :
saya coba menjalankan script :
LOOP
open allResult
fetch allResult into resultrecord;
exit when allResult%NOTFOUND;
EXECUTE IMMEDIATE SQLstmt;
update smsapp.PERFORMANCE set END_TIME = sysdate()
where smsapp.PERFORMANCE.ID = perfID;
commit;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
END LOOP;
harusnya seperti itu, tapi keluar error :
PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the
following:
begin case declare end exit for goto if loop mod null pragma
raise return select update while with <an identif
kalau block exception nya dibuang, procedurenya jalan lancar, tapi keluar
sendiri kalau terjadi exception
Terima kasih.
[Non-text portions of this message have been removed]
