Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: v$session.program
yong321_at_yahoo.com wrote:
> I would be interested to know whether anything other than JDBC thin
> driver, such as OCI, can change the program column value in v$session.
> Note:147413.1 has code that uses JDBC thin driver to achieve this, by
> setting a property "v$session.program".
Yes, I've read this. And if it's possible to do it with JDBC it should
also be possible with C/OCI.
> I'm not sure why the program name part changes to "?", as if the server
> process has intentionally modified its own argv[0]. If you write your
> own program, I believe you can do it (by setting the second argument of
> exec() to "?"). But I don't know if Oracle OCI can do that to Oracle.
I do not understand what you mean.
The OCI-programm is startet with
int execlp( const char *file, const char *arg, ...);
and no '?' is used as arg.
Wolf Received on Tue May 03 2005 - 02:04:16 CDT