hi Martin Vajsar
My DB is postgresql, and in a STORE_PROC , i have to do updates in a loop for a table,
suppose that loop do 100 updates one by one, I want to do it in a single batch as in java( addbatch, executebatch),
I have read somewhere I can put autocommit off before loop and commit after loop,
set autocommit off;
for loop
update query
end
commit;
so whole record will be update after loop, which is efficient, but could not able to implement that