Forum Discussion

ricardo_moura's avatar
ricardo_moura
Occasional Contributor
6 years ago

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

  • ricardo_moura's avatar
    ricardo_moura
    Occasional Contributor

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