Re: Open_cursor

What version? Generally, MAX_OPEN_CURSORS in your init - but if they're being opened through java, they will never be closed once opened. Though, if they're open, but not in use, java will reuse them....

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
> **********************

--
              ______________________________________
         ____/1___2___3___4___5___6___7___8___9__10_\___
        |____[_]_[_]_[_]_[_]_[_]_[_]_[_]_[_]_[_]_[_]____|
             \____________T___H___O___M_____________/