Re: how do you find oracle home on windows

From: jim mcnamara <jmcnamar_at_swcp.com>
Date: 19 Jul 2002 08:15:31 -0700
Message-ID: <19b60539.0207190715.5c308331_at_posting.google.com>

[Quoted] At the DOS prompt "SET" shows the environment variables, usually not "SET whatever", as this causes a syntax error

Programmatically (VB example)

---

Private Declare Function GetEnvironmentVariable Lib "kernel32" Alias "GetEnvironmentVariableA" (ByVal lpName As String, ByVal lpBuffer As String, ByVal nSize As Long) As Long

Function GetEnvironmentVar(sName As String) As String

    GetEnvironmentVar = String(255, 0)
    GetEnvironmentVariable sName, GetEnvironmentVar, Len(GetEnvironmentVar)

    If InStr(1, GetEnvironmentVar, Chr$(0)) > 0 Then GetEnvironmentVar = Left$(GetEnvironmentVar, InStr(1, GetEnvironmentVar, Chr$(0)) - 1)

    GetEnvironmentVar = sName + ": " + GetEnvironmentVar End Function

Private Sub Show_oracle_home()

    Me.AutoRedraw = True
    Me.Print GetEnvironmentVar("ORACLE_HOME") End Sub

---

jim mcnamara

"Steve Rainbird" <steve.rainbird_at_nospam.mssint.com> wrote in message news:<ah1gv6$672$1_at_paris.btinternet.com>...
> On Unix "echo $ORACLE_HOME"
> On Windows "set ORACLE_HOME"
>
>
> --
> Steve Rainbird
> Principal consultant
> MSS International Ltd.
> www.mssint.com
>
> Remove "nospam" from email address to reply
>
> "Joe Bayer" <u705413818_at_spawnkill.ip-mobilphone.net> wrote in message
> news:l.1026833106.1864440917_at_[64.94.198.252]...
> > *** post for FREE via your newsreader at post.newsfeed.com ***
> >
> > I might be a very easy question, but not for me who only works with unix
> until now.
> >
> > At unix, we can use env | grep ORA
> >
> > but what is the equivalent on Windows?
> >
> > Thanks for your help.
> >
> >
> >
> >
> >
> > --
> > Sent by joebayerii from hotmail part from com
> > This is a spam protected message. Please answer with reference header.
> > Posted via http://www.usenet-replayer.com/cgi/content/new
> >
> >
> > -----= Posted via Newsfeed.Com, Uncensored Usenet News =-----
> > http://www.newsfeed.com - The #1 Newsgroup Service in the World!
> > -----== 100,000 Groups! - 19 Servers! - Unlimited Download! =-----
> >
Received on Fri Jul 19 2002 - 17:15:31 CEST