Re: Retrieve the whole Hostname / Problem with Package utl_smtp

BKochs wrote:

> Hello everyone,
>
> UTL_INADDR.get_host_name()
> will get the Host: MYHOST
>
> but will not get the whole hostname
> MYHOST.MYDOMAIN.COM
>
> I use a W2K client.
> _______________________________________________________________________
> I guess the mailhost is the mailserver in the
> utl_smtp.open_connection( -function.
> But in the example here it's the same host with utl_smtp.helo(.
>
> In my script (you don't see here) the helo-mailhost must get the
> hostname of the clientmachine,the full hostname for
> example:MYHOST.MYDOMAIN.COM
> UTL_INADDR.get_host_name() will only retrieve MYHOST an this is my
> problem.
> The script / procedure will be executet on different machines.
>
> Greetings Bern Kochs
>
> EXAMPLE:
> PROCEDURE send_mail (sender IN VARCHAR2,
> recipient IN VARCHAR2,
> message IN VARCHAR2)
> IS
> mailhost VARCHAR2(30) := 'mailhost.mydomain.com';
> mail_conn utl_smtp.connection;
> BEGIN
> mail_conn := utl_smtp.open_connection(mailhost, 25);
> utl_smtp.helo(mail_conn, mailhost);
> utl_smtp.mail(mail_conn, sender);
> utl_smtp.rcpt(mail_conn, recipient);
> utl_smtp.data(mail_conn, message);
> utl_smtp.quit(mail_conn);
> EXCEPTION
> WHEN OTHERS THEN
> -- Handle the error
> END;
How about getting the IP address instead?

A demo of that capability with UTL_INADDR is available to www.psoug.org click on Morgan's Library
click on UTL_INADDR

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)