Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Cursors in ODBC Insert

Cursors in ODBC Insert

From: Bill Buchan <bbuchan_at_ossian.net>
Date: Fri, 13 Nov 1998 15:53:25 -0000
Message-ID: <72hkek$9s5$1@phys-ma.sol.co.uk>


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,

Received on Fri Nov 13 1998 - 09:53:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US