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 -> Help needed with "ORA-01000: maximum open cursors exceeded" error

Help needed with "ORA-01000: maximum open cursors exceeded" error

From: <g_chime_at_yahoo.com>
Date: 5 Apr 2006 10:07:19 -0700
Message-ID: <1144256839.638209.192430@v46g2000cwv.googlegroups.com> 





I am adding data to a table using the SQL insert command via ODBC;
after adding about 300 rows I am getting "ORA-01000: maximum open
cursors exceeded" errors.


I don't open any cursors explicitly. I have tired to issue a
"commit" after  each insert command.



Any help is appreciated.
Received on Wed Apr 05 2006 - 12:07:19 CDT












Original text of this message













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