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;