I have written a code in PL/SQL to send mail.
Code is as follows..
CREATE OR REPLACE PROCEDURE SEND_MAIL (
msg_to varchar2,
msg_subject varchar2,
msg_text varchar2 )
IS
c utl_smtp.connection;
rc integer;
msg_from varchar2(50) := 'abc@def.in';
mailhost VARCHAR2(30) := 'smtp.def.in'; -- local database host
BEGIN
c := utl_smtp.open_connection(mailhost, 25); -- SMTP on port 25
utl_smtp.helo(c, mailhost);
utl_smtp.mail(c, msg_from);
utl_smtp.rcpt(c, msg_to);
dbms_output.put_line(' Start Sending data');
utl_smtp.data(c,'From: Oracle Database' || utl_tcp.crlf ||
'To: ' || msg_to || utl_tcp.crlf ||
'Subject: ' || msg_subject ||
utl_tcp.crlf || msg_text);
dbms_output.put_line(' Finish Sending data');
utl_smtp.quit(c);
end;
/
The procedure created successfully.
when I execute the procedure with valid values like
execute send_mail('xxx@xyz.com','Test','This is a test message.');
/
then the following message comes.
ERROR at line 1:
ORA-29279: SMTP permanent error: 553 Authentication is required to send mail as
<abc@def.in>
ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 98
ORA-06512: at "SYS.UTL_SMTP", line 221
ORA-06512: at "SOIL.SEND_MAIL", line 14
ORA-06512: at line 1.
Now my question is how could i authenticate abc@def.in if it is a valid user and
if mailhost is also valid for that user.
Please help me to solve this problem...