CODEWITHSUNDEEP
oracle-database
kaze
kaze

Reputation: 4359

Program version using the database?

Is it possible to get more information about the program using an Oracle database except from the exe-name? I would like to have the exes version number and/or hash code or something else that allows me to uniquely distinguish one exe-file-version from another.

I don't necessary need to find this info in program code, an admin tool like Toad och Sql Developer would do fine.

Upvotes: 0

Views: 114

Answers (2)

Karl
Karl

Reputation: 3372

The only way I know to reliably get the info you want is to find the OS process ID (v$session) and then use a ps or something like taskmanager.exe to get detail from the client systems OS.

It sounds cumbersome but is scriptable if you have suffient rights on the client app's hosts.

Upvotes: 0

cagcowboy
cagcowboy

Reputation: 30828

Are you able to change the exe-s in question (ie is in an internal app)?

If so, you could set the version number using the DBMS_APPLICATION_INFO package...

http://www.orafaq.com/wiki/DBMS_APPLICATION_INFO

Upvotes: 1

Related Questions