Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: rgaffuri@cox.net (Ryan Gaffuri)
Newsgroups: comp.databases.oracle.tools
Subject: Re: Getting the IP address of a client over the web
Date: 5 Jun 2002 15:08:57 -0700
Organization: http://groups.google.com/
Lines: 56
Message-ID: <1efdad5b.0206051408.6681b129@posting.google.com>
References: <1efdad5b.0206040234.28f21a1b@posting.google.com> <3CFCDBA9.28ACA7EF@exesolutions.com>
NNTP-Posting-Host: 164.106.8.243
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1023314938 31751 127.0.0.1 (5 Jun 2002 22:08:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 5 Jun 2002 22:08:58 GMT
Xref: easynews comp.databases.oracle.tools:51661
X-Received-Date: Wed, 05 Jun 2002 15:06:23 MST (news.easynews.com)

Daniel Morgan <dmorgan@exesolutions.com> wrote in message news:<3CFCDBA9.28ACA7EF@exesolutions.com>...
> Ryan Gaffuri wrote:
> 
> > Posted this on the oracle.server board. Probably the wrong place. I
> > think Im looking for a forms level way to do this.
> >
> > I need to be able to get the IP address of a web client who is
> > accessing our web forms(we are using APACHE and not IAS) and have it
> > stored in a variable in some way for later use.
> >
> > SYS_CONTEXT does not work with the web. Just gives me the IP address
> > of the server. I would greatly prefer to do this in PL/SQL and not
> > with a Javabean(since I dont really know Java).
> >
> > Also, we have more than one user logging in with the same account. I
> > have no control over this and no way to change it.
> >
> > Thanks,
> >
> > Ryan
> 
> I am going to make one more attempt to help you and then I am washing my
> hands of the whole thing. It is extremely frustrating to give someone
> the answer to their problem several times and have them ignore it.
> 
> -- the procedure
> CREATE OR REPLACE PROCEDURE logproc IS
> 
> addr VARCHAR2(20);
> 
> BEGIN
>    IF (ora_sysevent = 'LOGON') THEN
>       addr := ora_client_ip_address;
>    END IF;
> 
>    -- then get the session information from v_$session and insert the
> lot into a table.
>    -- You can later query this table to get the IP Address whenever you
> need it.
> END logproc;
> /
> 
> -- the trigger that executes it
> CREATE OR REPLACE TRIGGER logintrig
> AFTER logon ON DATABASE
> CALL logproc
> /
> 
> Daniel Morgan

I understand your solution, however, management prefers that i not use
database code. Therefore, I first have to search for an alternative
solution. If I cannot come up with one, then Ill use the database
code.

Sorry for the misunderstanding