Maximum Open Cursors Exceeded

From: Lorrie Gagnon <gagnon_at_dsr.com>
Date: 1995/09/27
Message-ID: <44ch9j$4t4_at_news2.cts.com>#1/1

I'm using Oracle 7.1.3 and PL/SQL. I'm having a problem with my stored procedures exeeding the maximum open cursors value, which is currently set to 300. It appears, by looking in V$OPEN_CURSOR, that all of my implicit cursors are remaining active, rather than being reused.

Does anyone have any insight as to how I can work around or solve this problem? I would prefer not to rewrite all of my implicit cursors to be explicit, at this time.

Thanks in advance,
Lorrie Gagnon
gagnon_at_dsr.com Received on Wed Sep 27 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Louiqa Raschid: "Oracle for Dummies"
Previous message: Mark Pritchett: "Re: Turnstone Software Address Details please ?"
Next in thread: Lon Culbertson: "Re: Maximum Open Cursors Exceeded"
Reply: Lon Culbertson: "Re: Maximum Open Cursors Exceeded"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message