APEX

Hi,

I want to send an email from HTMLDB and I see that the HTMLB mail package also use the utl_smtp package to implement this function. So I write a store procedure to send email with the help of utl_smtp and it works. Additional to every send I want a delivery confirmation to the sender adress, because it is very important to see, which mails weren't delivered. I've searched for an parameter to set and found these syntaxes in the "PL/SQL Packages and Types Reference".

UTL_SMTP.MAIL (
c IN OUT NOCOPY connection,
sender IN VARCHAR2,
parameters IN VARCHAR2 DEFAULT NULL);

UTL_SMTP.RCPT (
c IN OUT NOCOPY connection,
recipient IN VARCHAR2,
parameters IN VARCHAR2 DEFAULT NULL)
RETURN reply;

UTL_SMTP.RCPT (
c IN OUT NOCOPY connection,
recipient IN VARCHAR2,
parameters IN VARCHAR2 DEFAULT NULL);

The following statement stay in the Reference for the description of "parameters":

parameters The additional parameters to RCPT command as defined in Section 6 of [RFC1869]. It should follow the format of "XXX=XXX (XXX=XXX ....)".

I read a little bit about SMTP in RFC1869 and I write change the statements:

utl_smtp.mail(mail_conn,sender);
utl_smtp.rcpt(mail_conn,recipient);

to:

utl_smtp.mail(mail_conn,sender, 'NOTIFY="SUCCESS,FAILURE"');
utl_smtp.rcpt(mail_conn,recipient, 'NOTIFY="SUCCESS,FAILURE"');

I get now the following syntax error: "ORA-29279: SMTP permanent error: 501 Syntax Error"

I tried also the statement without success:

utl_smtp.mail(mail_conn,sender, 'NOTIFY=SUCCESS,FAILURE');
utl_smtp.rcpt(mail_conn,recipient, 'NOTIFY=SUCCESS,FAILURE');

What can I do to get this delivery confirmation. E.g. in Outlook is possible to set this as option for emails before you send it. Any ideeas?

Thanks!

Serban Vettori