SQL & PL/SQL

Hi,

I am new to the forum so please excuse if I post incorrectly without conforming to the standards.

We need to send mails using the UTL.MAIL package and have installed them on the database.
Whenever I am trying to send an email I am getting the following error:

ERROR at line 1:
ORA-29279: SMTP permanent error: 501 Address Syntax Error in
some_email_Address@domain.com
ORA-06512: at "SYS.UTL_MAIL", line 654
ORA-06512: at "SYS.UTL_MAIL", line 671
ORA-06512: at line 2

The test code which I am running is as follows:

BEGIN
UTL_MAIL.send(sender => 'test <some_email_Address@domain.com>',
recipients => 'operator@xyz.com',
subject => 'UTL_MAIL test subject',
message => 'UTL_MAIL test body');
END;

I have tried different combinations:

BEGIN
UTL_MAIL.send(sender => 'test "<some_email_Address@domain.com>"',
recipients => 'operator@xyz.com',
subject => 'UTL_MAIL test subject',
message => 'UTL_MAIL test body');
END;

even tried

BEGIN
UTL_MAIL.send(sender => 'some_email_Address@domain.com',
recipients => 'operator@xyz.com',
subject => 'UTL_MAIL test subject',
message => 'UTL_MAIL test body');
END;

Everytime I am getting the same error.
This seems to be working with an exchange mail server but never on the SMTP server.

In the SMTP server logs the sender address is not having the angular brackets <> unlike the other mails which are being sent over.
It seems that the SMTP server is pretty strict and the SMTP admin will not change any settings on the server.

The oracle version is as follows

Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

Could you please help me out with a solution.
Some how the angular brackets are geting stripped off (which UTL MAIL package generally does), Is there any way in which I can include the angular brackets.

Edited by: 984757 on 29-Jan-2013 02:56

Edited by: 984757 on 29-Jan-2013 02:57