DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E2D4CE7.59D34C3E_at_exesolutions.com>...
> Stephan Born wrote:
>
> > DA Morgan schrieb:
> > > Sam wrote:
> > >
> > >>After I run ALTER SESSION.. such as
> > >>
> > >>ALTER SESSION SET SQL_TRACE = FALSE
> > >>
> > >>How do I set the session varible back to original state?
> > >>
> > >>Help?
> > >
> > > Is this a serious question?
> > >
> > > ALTER SESSION SET SQL_TRACE = TRUE
> >
> > I think the original poster wanted to know how to get the original
> > state, change this with
> >
> > ALTER SESSION SET SQL_TRACE = FALSE
> >
> > and after doing his work change it back to the original state with
> > something like
> >
> > ALTER SESSION SET SQL_TRACE = <original state>
> >
> > This could be necessary when the original state can be one of both TRUE
> > or FALSE. Unfortunately, I do not know how to get the original state.
> > But I am interested in this, too.
> >
> > Regards, Stephan Born
> > --
> > ---------------------------------------------------------------
> > Dipl.-Inf. (FH) Stephan Born | BRAIN FORCE SOFTWARE GmbH
> > | Landsberger Allee 366
> > eMail: delete the capital letters | 12681 Berlin
> > eMail: entferne die Grossbuchstaben | Germany
> > ---------------------------------------------------------------
> > PGP-Key verfügbar | PGP-Key available
> > ---------------------------------------------------------------
>
> I understood that. But the only way to know the original state is to write
> it down on a piece of paper.
>
> My point was ... if you changed it to FALSE then it must have been TRUE.
>
> You certainly wouldn't change somethign to FALSE if it was already FALSE.
>
> And the only other possibility would be if one were working with cubits
> and Oracle doesn't run on them yet.
>
> Daniel Morgan
Good Piont.
I would like to change the session state during the program. How do I
query all the state variables if I do not have admin rights?
Received on Thu Jan 23 2003 - 14:33:17 CST
