Hi there,

I am trying to use utl_smtp to send out email to our customers. How can we tell is the email successful delivered ? Does reply code indicate the successful of delivery ? Below is a testing procedure I had created. I got the same result on the reply code (250) whenever I send a valid email address or a dummy email address. Can you help me on this

CREATE OR REPLACE PROCEDURE SimpleTextMessage1 IS
mailHOST VARCHAR2(64) := 'mailhost.mydomain.com';
mailFROM VARCHAR2(64);
mailTO VARCHAR2(64);
mailCONN utl_smtp.connection;
mailDATE VARCHAR2(20);
vreply utl_smtp.reply;

BEGIN
mailFROM := 'test@mydomain.com';
mailTO := 'dummytestwo@yahoo.com';
SELECT TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS') INTO mailDATE FROM dual;


vreply := utl_smtp.open_connection(mailHOST, 25, mailCONN);

dbms_output.put_line('mail');
dbms_output.put_line('----');
vreply := utl_smtp.mail(mailCONN, mailFROM);
dbms_output.put_line( 'code = ' || vreply.code );
dbms_output.put_line( 'text = ' || vreply.text );

vreply := utl_smtp.rcpt(mailCONN, mailTO);
dbms_output.put_line('mailto');
dbms_output.put_line('----');
dbms_output.put_line( 'code = ' || vreply.code );
dbms_output.put_line( 'text = ' || vreply.text );


vreply := utl_smtp.open_data(mailCONN);
dbms_output.put_line('open_data');
dbms_output.put_line('----');
dbms_output.put_line( 'code = ' || vreply.code );
dbms_output.put_line( 'text = ' || vreply.text );

utl_smtp.write_data(mailCONN, 'Subject: '|| 'A subject' || chr(13));


utl_smtp.write_data(mailCONN, 'From: '||mailFROM || chr(13));
utl_smtp.write_data(mailCONN, 'Date: '||mailDATE || chr(13));
utl_smtp.write_data(mailCONN, 'To: '||mailTO || chr(13));
utl_smtp.write_data(mailCONN, 'CC: '||mailFROM || chr(13));
utl_smtp.write_data(mailCONN, 'BCC: '||mailFROM || chr(13));
utl_smtp.write_data(mailCONN, chr(13));
utl_smtp.write_data(mailCONN, 'Hello Friend.' || chr(13));
utl_smtp.write_data(mailCONN, 'Drop me an e-mail.' || chr(13));



vreply := utl_smtp.close_data(mailCONN);
dbms_output.put_line('close_data');
dbms_output.put_line('----');
dbms_output.put_line( 'code = ' || vreply.code );
dbms_output.put_line( 'text = ' || vreply.text );


vreply := utl_smtp.quit(mailCONN);

dbms_output.put_line('done');
dbms_output.put_line('----');
dbms_output.put_line( 'code = ' || vreply.code );
dbms_output.put_line( 'text = ' || vreply.text );


END;
/


Thanks,
Rebecca