Re: Retrieve remote host from a Stored procedure

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 30 May 2007 07:07:15 -0700
Message-ID: <1180534035.652387.15320@g4g2000hsf.googlegroups.com>

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_frm/thread/b912f0c2dea193be/5ea1cc7d59a3abac?lnk=st&q=&rnum=1&hl=en#5ea1cc7d59a3abac

HTH -- Mark D Powell -- Received on Wed May 30 2007 - 09:07:15 CDT