RE: Find client version
- From: "Nick Tilbury @ Northampton" <ntilbury@xxxxxxxxxxxx>
- To: "'Rudy.Zung@xxxxxxx'" <Rudy.Zung@xxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Nov 2004 07:49:05 -0000
You can get a bunch of session information, which I think you're looking
for, by using the SYS_CONTEXT object.
EG, SELECT SYS_CONTEXT('USERENV','OS_USER') FROM dual;
Will give the Operating System user for the current session.
Check the Oracle docs as there is a whole bunch of other info you can pick
up in this manner.
Hope this helps.
Nick
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Rudy Zung
Sent: 11 November 2004 15:36
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Find client version
Not quite what I was looking for. Our developers are
going to have a need for both 8i and 10g clients on=20
their machines; they'll be developing under ColdFusion.
After a connection has been made to an Oracle server,
we need the session itself to find out what version
of Oracle client got fired up to make the connection.
But, thanks for your answer anyway.
...Rudy
-----Original Message-----
From: Jeremiah Wilton [mailto:jwilton@xxxxxxxxxxxxx]=20
Sent: Wednesday, November 10, 2004 6:09 PM
To: Rudy Zung
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Find client version
On Wed, 10 Nov 2004, Rudy Zung wrote:
> Is there any way to programatically determine what=3D20
> version of client that I'm using?
You can find the client version in the client shared library:
strings $ORACLE_HOME/lib/libclntsh.so | grep ^Version
Not sure if this helps you. I suspect there is an OCI call you can
make to get this, but I didn't take the time to search around for it.
--
Jeremiah Wilton
Independent Oracle Professional
Oracle Certified Master
Disaster Recovery - Seminars - Technical Interviews
http://www.speakeasy.net/~jwilton
--
//www.freelists.org/webpage/oracle-l
=======================================================
This message is intended solely for the use of the individual or organisation
to whom it is addressed. It may contain privileged or confidential
information. If you have received this message in error, please notify the
originator immediately. If you are not the intended recipient, you should not
use, copy, alter, or disclose the contents of this message. All information or
opinions expressed in this message and/or any attachments are those of the
author and are not necessarily those of VarTecTelecom Europe Ltd or its
affiliates. VarTec Telecom Europe Ltd accepts no responsibility for loss or
damage arising from its use, including damage from virus.
=======================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
