ORA-01000: maximum open cursors ...

From: Theodor Ramisch <theodor_ramisch_at_hotmail.com>
Date: Fri, 26 Mar 2004 17:05:41 +0100
Message-ID: <406454d5$0$17748$9b4e6d93@newsread2.arcor-online.net>

Hi there,

we are currently working on an ASP.Net Application which uses a Oracle 9i database. On some pages we have to do about 60 queries to oracle. After loading a few pages, the number of cursors increases to 300 and we get the error ORA-01000: maximum open cursors exceeded.

Our C# DataReaders are closed after every statement, but the connection stays open for the whole session.

Why are the cursors left open after the querie is done? Do we have to close and reopen the connection at every page?

Regards,

Theodor Ramisch Received on Fri Mar 26 2004 - 10:05:41 CST