Re: Open_Cursor

Zeeshan

        You need to change a setting in your database configuration file e.g. initSID.ora . In the config file there should be a setting for open cursors. Something like

open_cursors = 100

You need to increase your setting for open_cursors, for example from 100 to 400. Once you've changed the setting you will need to restart your database instance.

Cheers
Johnny A  

Zeeshan Basharat <shani2000_at_usa.net> wrote in article <39d1bb07_at_news.cyber.net.pk>...
> 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 - 02:40:38 CEST