it is a parameter in the init.ora file. If it isn't already there you can
see what the default is by querying "select name,value from v$parameter
where name like '%open_cur%'; Then put the entry into your init.ora with
whatever setting you need. Oracle will require additional memory from the
system to allow for more cursors.
--
Dave A
"Zeeshan Basharat" <shani2000_at_usa.net> wrote in message
news:39d1bb06_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 Tue Sep 26 2000 - 20:21:50 CDT
