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

2011-12-21 Thread David Johnston
On Dec 21, 2011, at 0:36, Dinesh Kumara 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_contractli

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

2011-12-21 Thread 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,con