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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01000: maximum open cursors exceeded

Re: ORA-01000: maximum open cursors exceeded

From: Oliver Neumann <no_at_no.com>
Date: Fri, 16 Jun 2006 16:07:59 +0200
Message-ID: <e6udua$bp5$00$1@news.t-online.com> 





Hi Thomas,



> You have to make sure, you do close all ResultSets and all Statements

> (even more important, as every Statement maps to a cursor on the server

> side)




ah right. Thats the point...i hadnt this problem yet due the auto-close and
i didnt added a larger amount of rows at once yet so the auto.close worked
fine till now. Looks good now...the script is able to run without problems
now.




Thanks guys for the help,


oliver
Received on Fri Jun 16 2006 - 09:07:59 CDT












Original text of this message













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