logon trigger - getting program version information of application connecting

Not sure if this is possible, but just in case...

I have a logon trigger that I would like to modify to prevent users from connecting to an Oracle schema if the version of software they are using isn't current.

Oracle 8.1.7.4.12 (client and server)
TCP/IP - net8
Windows 2000 (clients and server)

I'm working with a 3rd party application that we are about to upgrade (major release) and have over 500 client installs using this application / database. I basically have no control over the application to prevent version mismatches, but due to the number of client installs, there's a potential for data problems because of missed client upgrades. I've already confirmed an older version of the client program can connect to the upgraded schema, and the software vendor is less than helpful in providing reassurance that the data will be protected (the "older versions aren't certified to run on the upgraded schema, but why wouldn't you upgrade all the client machines" type of response)

Oracle receives the application executable name in v$session (hasn't changed between versions), but I can't figure out how to get the version (or timestamp) of the executable. Either of these would allow me to drop the connection.

So far I've come up blank on all the searches I've done.

Any ideas? Can it be done? Any assistance appreciated.

Thanks,

Brad Received on Fri Mar 12 2004 - 03:10:17 CET