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

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 05 Apr 2006 11:17:39 -0700
Message-ID: <1144261057.612273@yasure.drizzle.com>


g_chime_at_yahoo.com wrote:
> 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.

Oracle version is?
Setting for open cursors in init.ora is? What is in v%open_cursors?
Which ODBC driver?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Apr 05 2006 - 13:17:39 CDT

Original text of this message

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