Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Cursors in ODBC Insert
I have some code which makes an ODBC connection to Oracle and then runs in a
loop doing inserts. Oracle very quickly runs out of cursors. I'm not quite
sure why this is happening - is the looping going so fast that a backlog of
open cursors gets built up? Is there any way around this apart from
increasing open_cursors to a much larger value? Is there some way of using
a single cursor to do all of the inserts?
Any info., as always, gratefully received!
Thanks,
![]() |
![]() |