select UTL_INADDR.get_host_address('HOST_NAME') from dual;

Salam,

Indra Armansyah.
[EMAIL PROTECTED]

  ----- Original Message ----- 
  From: Oscar Wilyanto 
  To: [email protected] 
  Sent: Friday, March 16, 2007 7:55 AM
  Subject: [indo-oracle] Dapetin IP address client di isqlplus


  Dear Masters,

  Saya ingin membuat trigger yang mencatat semua ip address yang melakukan 
loggin ke database, terutama yang melalui isqlplus..

  Bagaimana caranya? apakah ada paket khusus untuk ini?

  Thanks in Advance
  Oscar

  ----------------------------------------------------------
  This message contains confidential information and is intended only for the
  individual named. If you are not the named addressee you should not
  disseminate, distribute or copy this e-mail. Please notify the sender
  immediately by e-mail if you have received this e-mail by mistake and delete
  this e-mail from your system. E-mail transmission cannot be guaranteed to be
  secure or error-free as information could be intercepted, corrupted, lost,
  destroyed, arrive late or incomplete, or contain viruses. MKD Group therefore
  does not accept liability for any errors or omissions in the contents of this
  message, which arise as a result of e-mail transmission. If verification is
  required please request a hard-copy version. 

  MKD Group, www.mkdgroup.com
  ----------------------------------------------------------

  [Non-text portions of this message have been removed]



   


------------------------------------------------------------------------------


  No virus found in this incoming message.
  Checked by AVG Free Edition.
  Version: 7.5.446 / Virus Database: 268.18.11/722 - Release Date: 3/14/2007 
3:38 PM


[Non-text portions of this message have been removed]

Kirim email ke