Re: OracleConnection passing different application name by jimmyage
jimmyage
Mon May 08 21:49:01 CDT 2006
I know that when I use the Oracle Call Interface (OCI), I have the ability to
supply the program name when making a connection. I was hoping that with the
OracleClient ADO mechanism that I could do the same thing.
--
Jim Noeth
"Cowboy (Gregory A. Beamer)" wrote:
> The issue is impersonating an application. I do not know how you would
> implement this, but that is where I would look for answers, unless you want
> to create some mechanism that accepts an application name and circumvents
> the native way Oracle works (not advised).
>
> --
> Gregory A. Beamer
>
> *************************************************
> Think Outside the Box!
> *************************************************
> "jimmy@age" <jimmyage@noemail.noemail> wrote in message
> news:949FA84D-EC4C-4094-AD90-292BC99B82EB@microsoft.com...
> > I'm writing a web service that is executing a stored procedure on an
> > Oracle
> > data server. One of the things that this stored procedure does is to keep
> > track of 'who' is using it by storing some information from the V$SESSION
> > view. One of the columns being tracked is the client program name. But,
> > what
> > I'm getting is the name of the web service, but what I really want is the
> > name of the program calling the web service.
> >
> > Part of the framework that we have developped passes the calling program
> > name, so, I have that. What I don't know is how to pass that program name
> > instead of the web service program name. Does anyone have any ideas on
> > how
> > to do this? For instance is there an undocumented keyword/value pair that
> > can
> > be passed as part of the connection string. Or can I change the program
> > name
> > attribute of the service?
> >
> > Thanks
> > --
> > Jim Noeth
>
>
>