Terminating loop after 5 seconds
576930Dec 13 2011 — edited Dec 13 2011Hi forum,
I want to put an additional condition to terminate below LOOP after 5 seconds, is there any such function available?
Thank you.
LOOP
SELECT COUNT(1)
INTO v_tmp_cnt_ac
FROM accountdata;
EXIT WHEN v_cnt = v_tmp_cnt_ac;
END LOOP;