Re: Maximum Open Cursors Exceeded??

From: <kal121_at_my-deja.com>
Date: Wed, 25 Oct 2000 22:37:24 GMT
Message-ID: <8t7nb3$5mk$1@nnrp1.deja.com>

Raise the number of open cursors allowable by setting OPEN_CURSORS to a higher number in init.ora. Remember, Oracle also opens cursors, not just your application.

In article <8t7idl$fnr$1_at_crchh14.us.nortel.com>, "Vemula, Srinivas " <svemula_at_nortelnetworks.com> wrote:
> Is there a Rule of thumb to get rid of this problem??? We checked all
our
> stored procedures and made sure we explicitly close the cursors after
we are
> done.
>
> Ur help will be appreciated.
>
> Thanks
> Sri
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 25 2000 - 17:37:24 CDT