Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: PL/SQL cursor NOT closing
Hi Deepak,
you may want to query the v$open_cursor view for the relevant session to diagnose if there is a cursor leak or the open cursors limit is simple too low.
Jaromir
> 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.
>
>
> 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.
>>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 26 2007 - 10:40:27 CDT