Re: PL/SQL cursor NOT closing

You can generate either Oracle trace or error stack (alter session set events '1000 trace name errorstack level 3' or event="1000 trace name errorstack level 3" in init.ora/spfile) to diagnose the issue. I.e. see if it's really the cursor you think that is being problemmatic.

The commit should not have any affect on closing cursors. In fact the commit should only be done when the logic requires it.

Vlad Sadilovskiy
Oracle Database Tools
http://www.fourthelephant.com

On 9/26/07, DBA Deepak <oracle.tutorials_at_gmail.com> wrote:
>
> 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