Re: Open_cursor

From: pretzelman <pretzelman_at_fakeaddress.com>
Date: Wed, 27 Sep 2000 16:41:40 -0500
Message-ID: <C36CEE071225C4D2.C49B07835B06E0FA.417C9F438A8F4368@lp.airnews.net>

Can't you close the cursors when the query is finished? That's probably your problem. There is a configuration parameter for maximum number of cursors, but I'd have to look it up.

Pretzelman

Zeeshan Basharat wrote:

> From where I can increase the value of OPEN_CURSORS.
>
> My program shows this message when I use it frequently.
>
> ORA-01000 maximum open cursors exceeded.
>
> Please help me.
> Thanks in advance
>
> Bye,
> Zeeshan Basharat.
> ICQ:50080409
> **********************
Received on Wed Sep 27 2000 - 16:41:40 CDT