Message-Id: <10546.111077@fatcity.com> From: Rahul Date: Mon, 3 Jul 2000 11:41:35 +0700 Subject: RE: IP Address of a PC i am on 7.3.2, u can do it two ways.. 1) switch the session auditing ON for that user OR 2) 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@condor.nrl.navy.mil] > Reply To: ORACLE-L@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@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@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@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).