| SMTP error [message #7128] |
Thu, 22 May 2003 10:21 |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
Hi
I have the below script to send mail via SMTP...
create or replace PROCEDURE open_mail_server
IS
v_mailhost_c VARCHAR2(500);
v_mail_connection_c utl_smtp.connection;
v_message_c VARCHAR2(32767);
v_recipient_c VARCHAR2(500);
v_sender_c VARCHAR2(500);
v_subject_c VARCHAR2(500);
v_many VARCHAR2(1) := 'N';
-- Open Mail Server Connection
BEGIN
-- Set mail server conenction and perform initial handshake
v_mailhost_c := 'mailserver.domain.com';
v_mail_connection_c := utl_smtp.open_connection(v_mailhost_c);
utl_smtp.helo(v_mail_connection_c,v_mailhost_c);
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(sqlcode||':'||sqlerrm);
END;
Iam getting the following error when executing...
-29278:ORA-29278: SMTP transient error: 421 Service not available
Can anyone help in understanding how can i get the mail server name
Expecting your help
Thanks
Sam
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
