I am trying to query an oracle database and use a column from that db to drive the stored procedure in microsoft SQL server. At present I am using Access and VBA code to put the oracle DB into a variant and looping through to accomplish my goal. My issue is that it takes a minute and a half to go through approx. 1500 records. Which to me seems really long. I am looping with a For Next and inside of that I am calling a stored procedure with one parameter. At this time I can't provide any code but any thoughts would be greatly appreciated.
Comment