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 15:32:04 +0200
Message-ID: <e6ubr3$nrp$02$1@news.t-online.com> 





Hi dennis,



> I think that your transaction is too long.

> The cursor used to get the sequence number is not being closed until

> the transaction commits.





hmm i have no idea when i use cursors (like i told, im not this familiar
with oracle db's). I just send the SQL-Statement by jdbc and use the
resultset to get the return-values.



Who may i close the cursors ?




Thanks,


oliver
Received on Fri Jun 16 2006 - 08:32:04 CDT












Original text of this message













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