RE: SQLPlus version tracking
From: Blanchard, William G <William.Blanchard_at_fisglobal.com>
Date: Thu, 19 Jan 2012 19:50:27 +0000
Message-ID: <344DA095E78D444592EDB584D43B2AE4054809_at_LTCFISWMSGMB23.FNFIS.com>
Andy,
Thank you. The v$session_connect_info view has a client_driver which may give me what I'm looking for. It's obvious that Oracle has the information but how do I get it in a logon trigger? I tried client_driver with sys_context with no luck.
The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.
Date: Thu, 19 Jan 2012 19:50:27 +0000
Message-ID: <344DA095E78D444592EDB584D43B2AE4054809_at_LTCFISWMSGMB23.FNFIS.com>
Andy,
Thank you. The v$session_connect_info view has a client_driver which may give me what I'm looking for. It's obvious that Oracle has the information but how do I get it in a logon trigger? I tried client_driver with sys_context with no luck.
WGB
From: andyklock_at_gmail.com [mailto:andyklock_at_gmail.com] On Behalf Of Andy Klock
Sent: Thursday, January 19, 2012 1:33 PM
To: Blanchard, William G
Cc: oracle-l_at_freelists.org
Subject: Re: SQLPlus version tracking
There is a view v$session_connect_info that may give you what you are looking for. On Thu, Jan 19, 2012 at 2:19 PM, Blanchard, William G <William.Blanchard_at_fisglobal.com<mailto:William.Blanchard_at_fisglobal.com>> wrote: Does anyone know if there's a way to track the version of sqlplus that is connecting to the database? I looked at sys_context and system events but haven't found anything.
WGB
The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 19 2012 - 13:50:27 CST