Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg.SMTP Error while using UTL_MAIL in Oracle 10g

626103Mar 1 2008 — edited Mar 6 2008
Hi,

I am getting the following SMTP error while trying to use the UTL.MAIL package of Oracle 10g. The query is as follows.

begin
utl_mail.send(
sender => 'NAVEEN',
recipients => 'naveenkumar.c@tatatel.co.in',
subject => 'Testing utl_mail',
message => 'The receipt of this email means'|| ' that UTL_MAIL works'
);
end;

UTL_MAIL package is installesd and the port 25 is configured and firewall is changed.
The same block was working fine before 5 days and now is giving the error as

ORA-29279: SMTP permanent error: 501 badly formatted MAIL FROM user - no "<"
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 99
ORA-06512: at "SYS.UTL_SMTP", line 222
ORA-06512: at "SYS.UTL_MAIL", line 407
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 2

Could you please help me out how to proceed???

Regards,
Naveen Kumar.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 3 2008
Added on Mar 1 2008
14 comments
4,773 views