Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stored procedure failed: maximum open cursors exceeded

Re: Stored procedure failed: maximum open cursors exceeded

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 26 Jan 2006 22:46:34 +0100
Message-ID: <dngit1duu5ait7dcp2ec7r7qt08e883g4r@4ax.com> 





On 26 Jan 2006 12:21:24 -0800, Serguei.Goumeniouk_at_cibc.ca wrote:



> It seems implicit cursors are not closed after several calls of my

>stored procedure. Is it possible to close them?

>  Regards,

>    Serguei.




No.


That is one of the reason why I prefer explicit cursors in package
specs or on the package level in a package body.
I know Thomas Kyte is on a crusade against explicit cursors, but they
have their advantages.


--
Sybrand Bakker, Senior Oracle DBA


Received on Thu Jan 26 2006 - 15:46:34 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US