Postgresql, Autocommit, Oracle.
DEMO add unique(n); create or replace procedure my_inserts(n1 int, n2 int) as $$ begin for i in n1..n2 loop insert into DEMO values (i,current_timestamp); end loop; end; $$ language plpgsql; call my_inserts(10,12); call my_inserts(5,15); select * from DEMO; \q The first call has inserted values 10