Search:

thanks. In my try, it did not work and i got max connections reached exception. I moved the open/close outside the loop. I also thought theoratically it should work. but looks like the loop goes...

my question in not regarding my code.

My questions is if we loop open/close connection lets say 20k to 30k times, will that be a problem? I thought as long as we open and close, it should not...

I had existing function (f1) that opens and does select sql and returns results and closes connection.

Now I need to call the f1 many time. so in a loop

loop begins
f1
loop ends.

As...