i am on 7.3.2, u can do it two ways..
- switch the session auditing ON for that user
OR
- set the trace level to ADMIN in listener.ora and grep the IP
using the trace files and log files.
HTH
> ----------
> From: Gait, Christopher[SMTP:cgait_at_condor.nrl.navy.mil]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Sunday, July 02, 2000 11:13 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: IP Address of a PC
>
> In Oracle8i this context function is available:
>
> SELECT
> SYS_CONTEXT('USERENV', 'IP_ADDRESS')
> FROM
> Dual;
>
> and can easily be placed in PL/SQL. Here is an example modified from
> Feuerstein's Guide to Oracle 8i Features:
>
> DECLARE
> PROCEDURE showenv (str in VARCHAR2) IS
> BEGIN
> DBMS_OUTPUT.Put_Line(
> SYS_CONTEXT('USERENV', str)
> );
> END;
> BEGIN
> showenv('IP_ADDRESS');
> END;
>
>
> Regards,
> Chris Gait
>
> > -----Original Message-----
> > From: Alroy Mascrenghe [SMTP:mark_alroy_at_yahoo.co.uk]
> > Sent: Sunday, July 02, 2000 12:24 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: IP Address of a PC
> >
> > Hi All
> >
> > Any easy way of getting the PC's IP address to a PL
> > procedure?
> >
> > TIA
> >
> > ____________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
> > or your free @yahoo.ie address at http://mail.yahoo.ie
> >
> --
> Author: Gait, Christopher
> INET: cgait_at_condor.nrl.navy.mil
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Sun Jul 02 2000 - 23:41:35 CDT
