Re: Querying environment variables

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Mon, 4 Dec 2006 17:18:50 +0100
Message-ID: <45744a10$0$49197$14726298@news.sunsite.dk>

"Steve Howard" <stevedhoward_at_gmail.com> wrote in message news:1165247869.245611.234040_at_16g2000cwy.googlegroups.com...
>
> Radoulov, Dimitre wrote:
>> That's your client env, not the server env:
>
> Perhaps, but this is the case only when the client is on the server
> (and even then, only when the client has specifically overridden the
> env var value in existence when the instance was started).
>
> ...client on windows, server on linux...
[...]

Yes,
it seams the env of the server (shadow) process and it changes depending on the protocol you're using (on "who" forks the process) :

SQL> conn test/test
Connected.
SQL> !echo $TZ
GMT

SQL> var f varchar2(40)
SQL> set autop on
SQL> exec sys.dbms_system.get_env('TZ',:f);

PL/SQL procedure successfully completed.

F

---

GMT SQL> conn test/test_at_ora1022
Connected.
SQL> exec sys.dbms_system.get_env('TZ',:f);

PL/SQL procedure successfully completed.

F

---

MET Regards
Dimitre Received on Mon Dec 04 2006 - 10:18:50 CST