execute oracle script from JDBC teststep

[ricardo_moura]

hello,

i have below script to execute on oracle database:

DECLARE
v_sender NUMBER (20,0):= 10000000000001;
BEGIN
DELETE FROM table_A where key_field between 10000000000001 and 10000000000050;
FOR x IN 1..50
LOOP
  insert into table_A (key_field, field1, field2) VALUES (v_sender, 1234, 1234);
  v_sender := v_sender + 1;
END LOOP;
END;

if i execute on sql developer client, works fine, but via JDBC teststep on soapUI, does not work, soapui just stay executing, executing and executing for ever

my conection with DB its OK, i can execute simple selects, updates and deletes without any problems

thanks in advance

[ricardo_moura · Accepted solution]

l solve adding "COMMIT;" between end loop; and END;