 | |
utl_mail adds CRLF at beginning of varchar2 attachments
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
utl_mail adds CRLF at beginning of varchar2 attachments -
05-06-2008
, 02:00 PM
#2
| |||
| |||
|
#3
| |||
| |||
|
#4
| |||
| |||
|
#5
| |||
| |||
|
#6
| |||
| |||
|
|
neil kodner (nkod... (AT) gmail (DOT) com) wrote: : Using 10.2.0.3.0 on solaris, I'm trying to write some tests against : utl_mail.send_attach_varchar2. *I receive the email and the : attachments, but the attachment always begins with a leading blank : line. *I've tried varying the att_mime_type but am still having the : same problem. *The leading blank line is preventing applications from : interpreting my RTF text. : Here's the code I'm using. *This example uses RTF, but examples using : straight text have also failed (below) : rtf example: : exec * UTL_MAIL.SEND_ATTACH_VARCHAR2( : * * * * *sender => '... (AT) domain (DOT) com' : * * * * ,recipients => '... (AT) domain (DOT) com' : * * * * ,cc => NULL : * * * * ,bcc => *NULL : * * * * ,subject => 'send_attach_varchar2' : * * * * ,message => 'here is a test of send_attach_varchar2' : * * * * ,mime_type => 'text/plain; charset=us-ascii' : * * * * ,priority => 3 : * * * * ,attachment => '{\rtf1\ansi{\fonttbl\f0\fswiss Helvetica;} : \f0\pard This is some {\b bold} text.\par}' : * * * * ,att_inline => TRUE : * * * * ,att_mime_type=>'application/rtf' : * * * * ,att_filename => 'rtftest2.rtf' : * * ); : plain text example: : exec UTL_MAIL.SEND_ATTACH_VARCHAR2( : sender => '... (AT) oracle (DOT) com' : ,recipients => '... (AT) domain (DOT) com' : ,cc => NULL : ,bcc => NULL : ,subject => 'scheduled disco mail' : ,message => 'Testing testing testing' : ,mime_type => 'text/plain; charset=us-ascii' : ,priority => 1 : ,attachment => 'should be in my attachment' : ,att_inline => FALSE : ,att_mime_type => 'text/plain; charset=us-ascii' : ,att_filename => 'neil.txt' : ); I'm not familiar with UTL_MAIL, but the mime type of a message with attachments can't be 'text/plain; charset=us-ascii' . *It has to be some sort of multi part, like 'multipart/mixed' |
relates to MIME types, etc. However, I tried chaing the mime_type and
the att_mime_type to multipart/mixed (independently and together), and
each time, the email was sent without an attachment.
#7
| |||
| |||
|
|
neil kodner (nkod... (AT) gmail (DOT) com) wrote: : Using 10.2.0.3.0 on solaris, I'm trying to write some tests against : utl_mail.send_attach_varchar2. *I receive the email and the : attachments, but the attachment always begins with a leading blank : line. *I've tried varying the att_mime_type but am still having the : same problem. *The leading blank line is preventing applications from : interpreting my RTF text. : Here's the code I'm using. *This example uses RTF, but examples using : straight text have also failed (below) : rtf example: : exec * UTL_MAIL.SEND_ATTACH_VARCHAR2( : * * * * *sender => '... (AT) domain (DOT) com' : * * * * ,recipients => '... (AT) domain (DOT) com' : * * * * ,cc => NULL : * * * * ,bcc => *NULL : * * * * ,subject => 'send_attach_varchar2' : * * * * ,message => 'here is a test of send_attach_varchar2' : * * * * ,mime_type => 'text/plain; charset=us-ascii' : * * * * ,priority => 3 : * * * * ,attachment => '{\rtf1\ansi{\fonttbl\f0\fswiss Helvetica;} : \f0\pard This is some {\b bold} text.\par}' : * * * * ,att_inline => TRUE : * * * * ,att_mime_type=>'application/rtf' : * * * * ,att_filename => 'rtftest2.rtf' : * * ); : plain text example: : exec UTL_MAIL.SEND_ATTACH_VARCHAR2( : sender => '... (AT) oracle (DOT) com' : ,recipients => '... (AT) domain (DOT) com' : ,cc => NULL : ,bcc => NULL : ,subject => 'scheduled disco mail' : ,message => 'Testing testing testing' : ,mime_type => 'text/plain; charset=us-ascii' : ,priority => 1 : ,attachment => 'should be in my attachment' : ,att_inline => FALSE : ,att_mime_type => 'text/plain; charset=us-ascii' : ,att_filename => 'neil.txt' : ); I'm not familiar with UTL_MAIL, but the mime type of a message with attachments can't be 'text/plain; charset=us-ascii' . *It has to be some sort of multi part, like 'multipart/mixed' |
relates to MIME types, etc. However, I tried chaing the mime_type and
the att_mime_type to multipart/mixed (independently and together), and
each time, the email was sent without an attachment.
#8
| |||
| |||
|
|
neil kodner (nkod... (AT) gmail (DOT) com) wrote: : Using 10.2.0.3.0 on solaris, I'm trying to write some tests against : utl_mail.send_attach_varchar2. *I receive the email and the : attachments, but the attachment always begins with a leading blank : line. *I've tried varying the att_mime_type but am still having the : same problem. *The leading blank line is preventing applications from : interpreting my RTF text. : Here's the code I'm using. *This example uses RTF, but examples using : straight text have also failed (below) : rtf example: : exec * UTL_MAIL.SEND_ATTACH_VARCHAR2( : * * * * *sender => '... (AT) domain (DOT) com' : * * * * ,recipients => '... (AT) domain (DOT) com' : * * * * ,cc => NULL : * * * * ,bcc => *NULL : * * * * ,subject => 'send_attach_varchar2' : * * * * ,message => 'here is a test of send_attach_varchar2' : * * * * ,mime_type => 'text/plain; charset=us-ascii' : * * * * ,priority => 3 : * * * * ,attachment => '{\rtf1\ansi{\fonttbl\f0\fswiss Helvetica;} : \f0\pard This is some {\b bold} text.\par}' : * * * * ,att_inline => TRUE : * * * * ,att_mime_type=>'application/rtf' : * * * * ,att_filename => 'rtftest2.rtf' : * * ); : plain text example: : exec UTL_MAIL.SEND_ATTACH_VARCHAR2( : sender => '... (AT) oracle (DOT) com' : ,recipients => '... (AT) domain (DOT) com' : ,cc => NULL : ,bcc => NULL : ,subject => 'scheduled disco mail' : ,message => 'Testing testing testing' : ,mime_type => 'text/plain; charset=us-ascii' : ,priority => 1 : ,attachment => 'should be in my attachment' : ,att_inline => FALSE : ,att_mime_type => 'text/plain; charset=us-ascii' : ,att_filename => 'neil.txt' : ); I'm not familiar with UTL_MAIL, but the mime type of a message with attachments can't be 'text/plain; charset=us-ascii' . *It has to be some sort of multi part, like 'multipart/mixed' |
relates to MIME types, etc. However, I tried chaing the mime_type and
the att_mime_type to multipart/mixed (independently and together), and
each time, the email was sent without an attachment.
#9
| |||
| |||
|
|
neil kodner (nkod... (AT) gmail (DOT) com) wrote: : Using 10.2.0.3.0 on solaris, I'm trying to write some tests against : utl_mail.send_attach_varchar2. *I receive the email and the : attachments, but the attachment always begins with a leading blank : line. *I've tried varying the att_mime_type but am still having the : same problem. *The leading blank line is preventing applications from : interpreting my RTF text. : Here's the code I'm using. *This example uses RTF, but examples using : straight text have also failed (below) : rtf example: : exec * UTL_MAIL.SEND_ATTACH_VARCHAR2( : * * * * *sender => '... (AT) domain (DOT) com' : * * * * ,recipients => '... (AT) domain (DOT) com' : * * * * ,cc => NULL : * * * * ,bcc => *NULL : * * * * ,subject => 'send_attach_varchar2' : * * * * ,message => 'here is a test of send_attach_varchar2' : * * * * ,mime_type => 'text/plain; charset=us-ascii' : * * * * ,priority => 3 : * * * * ,attachment => '{\rtf1\ansi{\fonttbl\f0\fswiss Helvetica;} : \f0\pard This is some {\b bold} text.\par}' : * * * * ,att_inline => TRUE : * * * * ,att_mime_type=>'application/rtf' : * * * * ,att_filename => 'rtftest2.rtf' : * * ); : plain text example: : exec UTL_MAIL.SEND_ATTACH_VARCHAR2( : sender => '... (AT) oracle (DOT) com' : ,recipients => '... (AT) domain (DOT) com' : ,cc => NULL : ,bcc => NULL : ,subject => 'scheduled disco mail' : ,message => 'Testing testing testing' : ,mime_type => 'text/plain; charset=us-ascii' : ,priority => 1 : ,attachment => 'should be in my attachment' : ,att_inline => FALSE : ,att_mime_type => 'text/plain; charset=us-ascii' : ,att_filename => 'neil.txt' : ); I'm not familiar with UTL_MAIL, but the mime type of a message with attachments can't be 'text/plain; charset=us-ascii' . *It has to be some sort of multi part, like 'multipart/mixed' |
relates to MIME types, etc. However, I tried chaing the mime_type and
the att_mime_type to multipart/mixed (independently and together), and
each time, the email was sent without an attachment.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.