Re: Retrieve remote host from a Stored procedure

On May 30, 4:41 pm, 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 --
>
> I have checked your link....it seems that the view v$session is
> needed, but I don't have
> access to that view....(most likely because I'm logged to oracle as
> javauser and not as SYS......)- Hide quoted text -
>
> - Show quoted text -

Please look up the SYS_CONTEXT function in your SQL reference manual, and you won't need access to v$session.

--
Sybrand Bakker
Senior Oracle DBA