RE: PL/SQL cursor NOT closing

A code snippet would be helpful. (Platform and version may be as well)  

Are you opening a cursor for each of the 1000 deletes, deleting 1000 rows at a time or ???  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DBA Deepak Sent: Wednesday, September 26, 2007 2: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 




______________________________________________________________________

This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 


______________________________________________________________________




NOTICE OF CONFIDENTIALITY: Information included in and/or attached to this electronic mail transmission may be confidential. This electronic mail transmission is intended for the addressee(s) only. Any unauthorized disclosure, reproduction, or distribution of, and/or any unauthorized action taken in reliance on the information in this electronic mail is prohibited. If you believe that you have received this electronic mail transmission in error, please notify the sender by reply transmission, or contact helpdesk_at_multiplan.com, and delete the message without copying or disclosing it. 



______________________________________________________________________

This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 


______________________________________________________________________

--
http://www.freelists.org/webpage/oracle-l