PL/SQL cursor NOT closing

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Wed, 26 Sep 2007 12:05:57 +0530
Message-ID: <75aa80160709252335l103f4408rffc04b3b1ccb6654@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 26 2007 - 01:35:57 CDT