Re: Cursor loop - stop current iteration and continue with next iteration

On Dec 21, 2011, at 0:36, Dinesh Kumara <dinesh(at)rezgateway(dot)com> wrote:

> 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:dinesh(at)rezgateway(dot)com
> www.rezgateway.com
> <image002.png>

See

39.6.3.3

David J.