Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help needed with "ORA-01000: maximum open cursors exceeded" error
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