"Ora-01000 maximum open cursors exceeded" after update from 10.2.0.1 to 10.2.0.3

Hi all!

After updating our Database from 10.2.0.1 to 10.2.0.3 I get the error Ora-01000 in our application (we use the proC precompiler).

When I look at the v$open_cursor, I see the number of cursors increasing all the time.
In our application we have a lot of select statements and every statement is a cursor. But the cursor is always closed after the statement. And we also have a lot of transactions. And after a rollback the cursors should be closed automatic (am I right?).

It seams that neither a "EXEC SQL CLOSE ..." nor a "rollback" close the cursors any more!

The parameter session_cached_cursors is 20, the parameter open_cursors is set to 300.

With 10.2.0.1 we have no problems.
Has anyone an idea whats running wrong? Is there a new parameter?

Thanks in advance Received on Mon Jun 04 2007 - 01:25:09 CDT