[GENERAL] Cursor loop - stop current iteration and continue with next iteration

[Dinesh Kumara]

Greetings.. Please advice me how to stop current iteration of cursor loop and continue with next iteration . ... contractlistquery = '....'; OPEN rec_contractlist FOR EXECUTE contractlistquery;     LOOP     FETCH rec_contractlist INTO  contract_from_date,contract_to_date,contract_inv_type,contract_regionid;     IF NOT FOUND THEN     EXIT;     END IF;     IF contract_count = 0 THEN         contract_initial_region = contract_regionid;     END IF;         IF contract_initial_region <> contract_regionid THEN             [Need to stop current iteration and continue with next iteration.]        ELSE         ...         More  logic s here...         ...         END IF;     END LOOP; CLOSE rec_contractlist; ... Really appreciate if you can help me on this. -- Thanks and Regards, Dinesh Kumara, Software Engineer, Reservation Gateway Inc, Email:din...@rezgateway.com www.rezgateway.com