On 30 Mag, 16:37, Valentin Minzatu <valentinminz..._at_yahoo.com> wrote:
> On May 30, 10:33 am, Laura <f.marchi..._at_pride.it> wrote:
>
>
>
>
>
> > On 30 Mag, 16:07, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
>
> > > On May 30, 9:54 am, Laura <f.marchi..._at_pride.it> wrote:
>
> > > > Hi all,
> > > > is it possible to retrieve from a Stored Procedure the remote
> > > > host name or address who owns the Session ?
> > > > Thanks
> > > > Laura
>
> > > What do you mean by "address who owns the Session?"
>
> > > Do you want the SID and other information related to the remote
> > > session in a distributed transaction?
>
> > > See the following article and repost with a more specific question.
>
> > > How do I find distributed queries / transactions (either issued from
> > > or connecting to this instance)? http://www.jlcomp.demon.co.uk/faq/find_dist.html
>
> > > The following thread may also be of interest:http://groups.google.com/group/comp.databases.oracle.server/browse_fr...
>
> > > HTH -- Mark D Powell --
>
> > Hello, thanks for your reply.
> > Well I'm calling the Stored Procedure from a Java Servlet with Jdbc.
> > So I neet to know the remote address(or host) of the Servlet (that
> > launched the Stored Procedure).
>
> > Is it possible to do it ?
> > Thanks
> > Laura- Hide quoted text -
>
> > - Show quoted text -
>
> Do you need to retrieve that information in the same database session
> or from a different one?- Nascondi testo tra virgolette -
>
> - Mostra testo tra virgolette -
in the same database session (if I understand well: without quitting
the stored procedure)
Received on Wed May 30 2007 - 10:08:26 CDT
