Re: limitation of CURSORs

Nandakumar <nanban_at_my-deja.com> wrote:
> It looks like, i opened many dynamic cursors from within a procedure
> and didn't close them in the end. And now, i am at a level
> where i can't open any more cursors. How could i close these
> cursors so that further cursors can be opened.

> There should be some DICT table that records the status of cursors with
> cursor ids, i guess.

> Would appreciate any solution to this probelm.

> Thanks

> In article <7o564l$bff$1_at_nnrp1.deja.com>,
> Nandakumar <nanban_at_my-deja.com> wrote:

>>
>>
>> When i try to drop a view, i get an error that says maximum CURSOR

>> has exceeded.
>>
>> Anyone can give an idea on how this can be reset?
>>
>> drop view table1
>> *
>> ERROR at line 1:
>> ORA-00604: error occurred at recursive SQL level 1
>> ORA-01000: maximum open cursors exceeded
>>
>> Thanks
>> --
>> Nandakumar
>> Systems Analyst
>> New York
>> (N.Kumar_at_rocketmail.com)
>>
>> Sent via Deja.com http://www.deja.com/

>> Share what you know. Learn what you don't.
>>

> --
> Nandakumar
> Systems Analyst
> New York
> (N.Kumar_at_rocketmail.com)

> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Add:

       open_cursors = #
to the init.ora file with #>64 .

Every access to a table or joined table lets an open cursor to your session. If you need more than the default of 64 you can enlarge the number without problems.

Johannes Received on Wed Aug 04 1999 - 02:55:20 CDT