Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> newbie question about LOOP
In the following cursor, if the exception is encountered, the sql termnates. How can I do a continue loop in order for the process to continue with the next value ?
Thanks,
JT
DECLARE
v_rialto_id varchar2(12); v_newval number; v_counter number;
v_counter := v_counter + 1; FETCH C1 INTO v_rialto_id; SELECT newval INTO v_newval FROM rialto_val WHERE RTRIM(oldval) = RTRIM(v_rialto_id); UPDATE ibl_rialto_doc_log SET rialto_id = TO_CHAR(v_newval) WHERE CURRENT OF C1; IF v_counter = 100 THEN COMMIT; v_counter := 0; exit; END IF;
NULL;
END;
/
-- Jorge Torralba SMG Applications Group Intel 5200 N.E Elam Young parkway JF1-18 Hillsboro OR, 97124 (503) 712-1731 Jorge.Torralba_at_Intel.com ---------------------------------------------------------------- Any views or opinions expressed by me do not reflect those of Intel Corp.Received on Sun Jan 30 2000 - 00:00:00 CST