Hi,

This review is so very good. I am just the beginner in Oracle and i am trying to send create a procedure which
will send a automated message from server to the me.

this helped me a lot. and thanks a lot for maintaing a
good website.

RAMS

Dear Tom,

Thank for your detailed suggestions, actually i have posted my review about this UTL_SMTP before, but after i saw my own review i recognised that i missed so many words and letters in my typing,so i am doing this once again.

Anyway..s thanx for your suggestions.

Thanks
Ramesh.

Hi Tom,
I have this problem. I have read about the vrfy function in the UTL_SMTP package . I would like to use the same but the oracle docs dont provide the necessary information on thins neither i have found a singe example on this site which uses it. Could you please give me a imple eample.

Thanks,
Rahul.

Hi Tom,
I know the functionality of vrfy function but what i am looking for is ow do i use it to check if the addredd is valid ? As far as have read about this package its mentioned that for a correct address it will return the user name I(nothing is mentioned about the wrong address).
One of the document saya it will return me 250 for correct.
Now i want a simple example which shows me how do i check it in a pl/sql.
I had tried to take the o/p in a variable but but that didn't work out.If i give it directly oracle returns error saying the function must be first declared.
So if you could give me some link or some pl/sql where
the vrfy function is used it would be very helpful to me.

Thanks,
Rahul.

utl_smtp.vrfy is documented to be a funtion that returns a reply record.  A reply record is documented to consist of the code returned (number) and the text of the message returned.

So, here is the above telnet example done up in plsql, based on things read from the documentation of utl_smtp:


ops$tkyte@ORA9IR2> create or replace
  2  PROCEDURE verify( p_recipient IN VARCHAR2 )
  3  as
  4     l_mailhost VARCHAR2(255) := 'aria.us.oracle.com';
  5     l_mail_conn utl_smtp.connection;
  6     l_reply     utl_smtp.reply;
  7  BEGIN
  8     l_mail_conn := utl_smtp.open_connection(l_mailhost, 25);
  9     utl_smtp.helo(l_mail_conn, l_mailhost);
 10     l_reply := utl_smtp.vrfy( l_mail_conn, p_recipient );
 11     dbms_output.put_line( 'code = ' || l_reply.code );
 12     dbms_output.put_line( 'text = ' || l_reply.text );
 13     utl_smtp.quit(l_mail_conn);
 14  end;
 15  /
 
Procedure created.
 
ops$tkyte@ORA9IR2> exec verify('tkyte');
code = 252
text = 2.5.2 Cannot VRFY user; try RCPT to attempt delivery (or try finger)
 
PL/SQL procedure successfully completed.




Not sure why this is mystifying???  
 

Hi Tom,
Thanks for the reply. The whole thing was mystifying for i was assigning the o/p to a varchar2. Thanks once again.

Mike, I am developing a procedure to pick the mail ids from my customer table and send them mail using UTL_SMTP, your site was very helpful in developing the code, I am just missing one functionality in my programs I want to track whether mail has been delivered to the customer or bounced back because of invaild mail id is there any way to verify that. I used you procedure....
create or replace
2 PROCEDURE verify( p_recipient IN VARCHAR2 )
3 as
4 l_mailhost VARCHAR2(255) := 'LocalHost';
5 l_mail_conn utl_smtp.connection;
6 l_reply utl_smtp.reply;
7 BEGIN
8 l_mail_conn := utl_smtp.open_connection(l_mailhost, 25);
9 utl_smtp.helo(l_mail_conn, l_mailhost);
10 l_reply := utl_smtp.vrfy( l_mail_conn, p_recipient );
11 dbms_output.put_line( 'code = ' || l_reply.code );
12 dbms_output.put_line( 'text = ' || l_reply.text );
13 utl_smtp.quit(l_mail_conn);
14 end;
15 /

Procedure created.

ops$tkyte@ORA9IR2> exec verify('vashisthatarun@rediffmail.com');
code = 252
text = 2.5.2

PL/SQL procedure successfully completed.


ops$tkyte@ORA9IR2> exec verify('vashisthatarunabcd99231@rediffmail.com');
code = 252
text = 2.5.2

PL/SQL procedure successfully completed.

there was no difference in 2 vashisthatarunabcd99231 is not a valid email id. how can I track whether the mail has been delivered to recipient or bounced back.

many thanks for your help.

But who is Mike ???

First off, Thanks a lot for reply i had never expected such a fast reply.

Second : sorry, while posting this qustion I was talking to mike and by mistake typed his name here.

Third :


Tom,

can you guide me in writing a procedure which check that a mail has been delivered to Recipient or bounced back and return some value in case of failure or success.

Thanks.

Hi Tom,

How can i caputure the bounced emails and how can i redirect it.

Please help on this