Skip to Main Content

SQL Developer

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!

I get an SMTP Transient Error 501: attribute too long

VmanJul 4 2011 — edited Jul 5 2011
I have an email programme built using PL/SQL. It fails when the email is over 6K bytes long. It fails when the line "utl_smtp.close_data(v_connection);" is executed.
The following message/s returned :- "SMTP Transient error: 501Attribute too long" I also receive the message "SMTP Transient error: 421 Service not available"

Both of these error messages report against a valid emal address and don't occur if the email message is below 5K.
The mail server will accept emails up to 10MB

From the point of construction:
1) I collect the necessary data
2) I build 'The Email' (this is a CLOB)
3) I connect to the SMTP servicer
4) Open the connection for data
5) Then in a loop, write the data
6) exit the loop when all data written
7) At the instruction "utl_smtp.close_data(v_connection);" the it all turns to tears. Giving me "SMTP Transient error: 501Attribute too long" and sometimes "SMTP Transient error: 421 Service not available"

The programme works fine on email being only a few Kb in size.

Can anybody suggest what the problem may be and /or a method of resolving it aside from spliting the email into smaller secting then sending each section.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2011
Added on Jul 4 2011
1 comment
473 views