Oracle parameter array binding from c# executed parallel and serial on different servers
- by redir_dev_nut
I have two Oracle 9i 64 bit servers, dev and prod. Calling a procedure from a c# app with parameter array binding, prod executes the procedure simultaneously for each value in the parameter array, but dev executes for each value serially.
So, if the sproc does:
select count(*) into cnt from mytable where id = 123;
if cnt = 0 then
insert into…