Ask a Question

execute oracle script from JDBC teststep

SOLVED
ricardo_moura
Occasional 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

 

Sem título.png

 

thanks in advance

1 REPLY 1
ricardo_moura
Occasional Contributor

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

cancel
Showing results for 
Search instead for 
Did you mean: