DELIMITER $$ DROP PROCEDURE IF EXISTS `prc_lock_test2` $$ CREATE PROCEDURE `prc_lock_test2`() begin declare i int(11) default 1; while i>0 and i<200 do SELECT func_seq_get_next_number('EV_COMBINED_SEQ') FROM DUAL; -- call prc_seq_get_next_number('EV_COMBINED_SEQ'); /* update test set last_number = last_number + (increment_by) where upper(name) = 'EV_COMBINED_SEQ'; select last_number from test where upper(name) = 'EV_COMBINED_SEQ'; */ set i = i+1; end while; end $$ DELIMITER ;