Re: Retrieve remote host from a Stored procedure

On May 30, 10:33 am, Laura <f.marchi...@xxxxxxxx> wrote:
On 30 Mag, 16:07, Mark D Powell <Mark.Pow...@xxxxxxx> wrote:





On May 30, 9:54 am, Laura <f.marchi...@xxxxxxxx> 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?

.

Relevant Pages

  • Re: Retrieve remote host from a Stored procedure
    ... host name or address who owns the Session? ... 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 ...
    (comp.databases.oracle.server)
  • Re: How can I connect to console session using remote desktop conn
    ... one interactive session, so the host session will be locked ... Jeffrey Randow (Windows Networking & Smart Display MVP) ... Remote Networking Technology Support Site - ... >the active session on the host machine. ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Auto - login when resuming from remote desktop ?
    ... there - but are no longer actually in front of the PC - but at a remote ... You start a remote desktop connection to the host and log in as ... To end your session, instead ... If you have the screensaver set to return to the welcome screen after a ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Remote Desktop vs. GoToMyPC
    ... My understanding of GTMPC is that when a session from a host PC to a remote ... computer is established, a unique access code is generated from the host PC, ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Retrieve remote host from a Stored procedure
    ... What do you mean by "address who owns the Session?" ... Do you want the SID and other information related to the remote ... 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 ...
    (comp.databases.oracle.server)