470,863 Members | 1,241 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,863 developers. It's quick & easy.

UTL_SMTP Stripping MIME-Version header information


I am attempting to attach a .pdf file to an email generated using
oracle's utl_smtp. I am working on Oracle9i Enterprise Edition Release I beleive that the utl_smtp.write_data is stripping out
part of what I am passing to it. Here is the code I am having trouble

utl_smtp.write_data(conn, 'From: "Curious George" <cg@apollogrp.edu>
utl_smtp.write_data(conn, 'To: "Scott Watson" <'||v_recipient||'>
utl_smtp.write_data(conn, 'Subject: '||v_subject||' '||crlf);
utl_smtp.write_data(conn, 'Date: '||to_char(sysdate,'Day, DD Mon YYYY
utl_smtp.write_data(conn, 'MIME-Version: 1.0'||crlf);
utl_smtp.write_data(conn, 'Content-Type: '||v_content_type||'
utl_smtp.write_data(conn, ' boundary"'||v_boundary||'"'||crlf);
utl_smtp.write_data(conn, 'X-Priority: '||v_priority||' '||crlf);
utl_smtp.write_data(conn , 'X-Unsent: 1'||utl_tcp.CRLF);
utl_smtp.write_data(conn, 'X-MSMail-Priority: Normal'||crlf);
utl_smtp.write_data(conn ,'X-Unsent: 1'||crlf);
utl_smtp.write_data(conn ,'X-MimeOLE: Produced By Microsoft MimeOLE

I saved the email as a .txt file to see what was going on:

From: Curious George [cg@apollogrp.edu]
Sent: Thursday, March 03, 2005 1:49 AM
To: Scott Watson
Subject: Store IRN Nbr for all Factulty

Importance: High

The 'From:', 'To:' and 'Subject:' are written correctly but the rest is
stripped out. The x-priority is changed to 'Importance' so I am
assuming that utl_smtp is checking out what I am passing and making
changes to or excluding some information that is passed.
If I remove the 'Importance: High' and replace it with the information
that was stripped out the attachment works.

I guess my question is, why is this information being stripped out,
does utl_smtp not support setting up the MIME information? And can I
view the source code of the utl_smtp package to see exactly what it is
doing when it removes this information?


Scott Watson

Jul 19 '05 #1
0 4596

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jorge Pinto | last post: by
2 posts views Thread by Patrick | last post: by
4 posts views Thread by Spondishy | last post: by
7 posts views Thread by Edward Elliott | last post: by
1 post views Thread by fabrizio.viggiani | last post: by
reply views Thread by comp.lang.php | last post: by
1 post views Thread by comp.lang.php | last post: by
1 post views Thread by Anna C. Dent | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.