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
> I don't open any cursors explicitly. I have tired to issue a
> "commit" after each insert command.
Every SQL statement requires at least one cursor, whether you explicitly declare it or not. Some cursors are implicitly defined. For instance, issuing the following:
SELECT sysdate FROM dual;
will open at least one cursor. Plus, you'll need cursors for recursive SQL statements.
It appears that your OPEN_CURSORS initialization parameter is set too low to support your application needs. In many cases, but not all, the default value for this parameter is not sufficient. Consider raising this parameter.
HTH,
Brian
-- =================================================================== Brian Peasland oracle_dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Wed Apr 05 2006 - 13:33:34 CDT