ricardo_moura
6 years agoOccasional Contributor
execute oracle script from JDBC teststep
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
l solve adding "COMMIT;" between end loop; and END;