RE: PL/SQL cursor NOT closing

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.

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

Other related posts: