cancel
Showing results for 
Search instead for 
Did you mean: 

execute oracle script from JDBC teststep

SOLVED
Highlighted
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 ACCEPTED SOLUTION

Accepted Solutions
Occasional Contributor

Re: execute oracle script from JDBC teststep

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

View solution in original post

1 REPLY 1
Occasional Contributor

Re: execute oracle script from JDBC teststep

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

View solution in original post