Missing entry in V$SESSION.PROGRAM

From: Michael Reiche Jakobsen <mrj_at_schilling.dk>
Date: 10 Sep 1998 23:34:10 GMT
Message-ID: <01bddccc$2236d5a0$1d0a010a@pc65-w95>

Hello,

A lot of people have asked how to get entries in the V$SESSION.PROGRAM column. And always the answer have been: Look at the DBMS_APPLICATION_INFO package. But this only give access to the V$SESSION.CLIENT_INFO column. This might do it for some. But since oracle's own binaries, and Visual-Basic sessions via ODBC, can report the name of program, there must be a way to get my C-programs (using OCI) to do the same thing. I have been looking through my OCI-reference, and seen no calls to implement this.

Is the answer to this question such a big secret, or has anyone found a way?

Michael Reiche Jakobsen Received on Thu Sep 10 1998 - 18:34:10 CDT