Re: open cursor limit?

From: Mike Krolewski <mkrolewski_at_rosetta.org>
Date: Tue, 05 Dec 2000 18:11:37 GMT
Message-ID: <90jb4h$f1g$1@nnrp1.deja.com>

In article <90ja1u$dvc$1_at_nnrp1.deja.com>, susana73_at_hotmail.com wrote:
> Hi,
>
> I have open_cursor=250 and keeping getting the maximum cursor error
> message. I am wondering can I increase it as large as I want? What
> kind of resource will it take on the server if I increase it? Does it
> take up any resource even my apps is not running?
>
> Thanks,
> Susan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

You might want to look into what is causing you to consume so many cursors. My prior experience is that your code is not closing a cursor or that you are recursively requesting cursors -- both are not good programming. This is especially important in packages. Look for explicit cursor opens. Implicit cursors associated with a single select or loops are by definition safe.

I cannot image having more than 5 cursor open at any given time for any given program.

Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rosetta.org

Ususual disclaimers

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 05 2000 - 12:11:37 CST