RE: PL/SQL cursor NOT closing
- From: "Boyle, Christopher" <Christopher.Boyle@xxxxxxxxxxxxx>
- To: <oracle.tutorials@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Sep 2007 08:40:45 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxx, 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
______________________________________________________________________
Other related posts:
