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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: PL/SQL cursor NOT closing

RE: PL/SQL cursor NOT closing

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Wed, 26 Sep 2007 07:07:17 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3097A8BFC@x6009a.umb.corp.umb.com>


Usually that error means that you are not committing often enough. Did someone forget a commit command in the code?  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DBA Deepak Sent: Wednesday, September 26, 2007 1:36 AM To: oracle-l
Subject: PL/SQL cursor NOT closing  

Hi All,  

Have a PL/SQL stored procedure, which is doing DELETE from a table 1000 time. And the same procedure is getting called many times from the application. (Am not using any explicit cursors inside the stored procedure)  

My problem is am getting "ORA-01000: maximum open cursors exceeded" exception.  

I think Oracle should sclose the implicit cursor opened by the DELETE after the execution goes out of scope.  

Is there any reasoning behind this and any solution to this issue?  

Please help.

-- 
Regards,

Deepak
Oracle DBA 


------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  The information is exclusively for the use of the individual or entity intended as the recipient.  If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited.  If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

==============================================================================


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 26 2007 - 07:07:17 CDT

Original text of this message

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