Home » SQL & PL/SQL » SQL & PL/SQL » Error in email
Error in email [message #323949] Fri, 30 May 2008 02:32 Go to next message
art_ora
Messages: 10
Registered: May 2008
Junior Member
Hi everyone this is my code
PROCEDURE Send_Mail (p_sender IN VARCHAR2,
p_recipient IN VARCHAR2,
p_message IN VARCHAR2)
AS
l_mailhost VARCHAR2(255) := 'northpineland.com'; --email server
l_mail_conn utl_smtp.connection;
BEGIN
l_mail_conn := utl_smtp.open_connection(l_mailhost, 25);
utl_smtp.helo(l_mail_conn, l_mailhost);
utl_smtp.Mail(l_mail_conn, p_sender);
utl_smtp.rcpt(l_mail_conn, p_recipient);
utl_smtp.open_data(l_mail_conn );
utl_smtp.write_data(l_mail_conn, p_message);
utl_smtp.close_data(l_mail_conn );
utl_smtp.quit(l_mail_conn);
END;

have an error, please help me to find a solution when i run this with this parameter
Send_Mail( 'northpineland.com', 'artolazomail@yahoo.com', 'this is only a sample.' );

ORA-20000: Failed to send mail due to the following error: ORA-29279: SMTP permanent error: 550 5.7.1 Unable to relay for artolazomail@yahoo.com
ORA-06512: at "PROD_USER.SEND_MAIL", line 29
ORA-06512: at line 2

thanks
Re: Error in email [message #323956 is a reply to message #323949] Fri, 30 May 2008 02:46 Go to previous message
ora_baby
Messages: 89
Registered: May 2008
Member
error is

ora-29279: SMTP permanent error: string
Cause: A SMTP parametr error ocurred
Action: Correct the error and retry the SMTP operation

Previous Topic: Date difference with in rows on the same column using group by
Next Topic: PIPE_ROW() & pipelined function (merged)
Goto Forum:
  


Current Time: Sun Dec 04 12:57:44 CST 2016

Total time taken to generate the page: 0.07181 seconds