Re: Maximum Open Cursors Exceeded??

Vemula,

  There are two good answers here. It also depends on your application. I have worked in development environments where the dev databases needed a high number of cursors but in production that number was reduced drastically and vice versa.

  good luck...

"Vemula, Srinivas " <svemula_at_nortelnetworks.com> wrote in message news:8t7idl$fnr$1_at_crchh14.us.nortel.com...
> 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
>
>
Received on Fri Oct 27 2000 - 10:25:19 CDT