Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!cyclone.bc.net!news.glorb.com!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: scott.watson@apollogrp.edu
Newsgroups: comp.databases.oracle
Subject: UTL_SMTP Stripping MIME-Version header information
Date: 3 Mar 2005 08:45:04 -0800
Organization: http://groups.google.com
Lines: 53
Message-ID: <1109868304.494232.58070@g14g2000cwa.googlegroups.com>
NNTP-Posting-Host: 204.17.26.4
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1109868310 12698 127.0.0.1 (3 Mar 2005 16:45:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 3 Mar 2005 16:45:10 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=204.17.26.4;
   posting-account=5UPFxw0AAAAPZtxe5DbpcHbzOi-wsxcw
Xref: dp-news.maxwell.syr.edu comp.databases.oracle:29291

Hello,

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
9.2.0.4.0.  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
with:

utl_smtp.write_data(conn,  'From: "Curious George" <cg@apollogrp.edu>
'||crlf);
utl_smtp.write_data(conn,  'To: "Scott Watson" <'||v_recipient||'>
'||crlf);
utl_smtp.write_data(conn,  'Subject: '||v_subject||' '||crlf);
utl_smtp.write_data(conn,  'Date: '||to_char(sysdate,'Day, DD Mon YYYY
HH:MI:SS')||crlf);
utl_smtp.write_data(conn,  'MIME-Version: 1.0'||crlf);
utl_smtp.write_data(conn,  'Content-Type: '||v_content_type||'
'||crlf);
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
V5.00.2919.6700'||crlf);

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?

Regards,

Scott Watson