Re: changing open_cursor in TOAD

dbyy <dbyy_at_nirvana.com> wrote in message news:<24IGc.22790$WM5.1031968_at_news20.bellglobal.com>...
> hi everyone,
>
> I wonder whether someone can tell me - I'm sure someone can :-) -,
> why I can change the open cursor in one installation through TOAD
> and in another install I can't.
> These are two totally different installations.
> One install is Oracle 9.2 (can change cursors) the other one is Oracle
> V 8.1.5 (can't change cursors).
>
> Same is when I try to change the cursors through SQL*Plus, one is
> working, the other is not.
>
> I assume at the end it's the installation of Oracle.
> One install (V 9.2 which is working) I did by myself (default install),
> the other was installed by someone else (seems to me is a customized
> install) and possibly not proper installed.
>
> Might be someone can point me to the problem.
>
> Any help much appreciated.
>
> Tkx
>
> Fred

In Oracle 9i you have the option to change dynamically almost all parameters. This is a new feature of 9i.
And Oracle 8.1.5 was desupported in the previous century.

Sybrand Bakker
Senior Oracle DBA Received on Wed Jul 07 2004 - 09:36:49 CEST