Home » SQL & PL/SQL » SQL & PL/SQL » utl_mail.send to/from format/appearance
icon5.gif  utl_mail.send to/from format/appearance [message #184948] Fri, 28 July 2006 18:14 Go to next message
aughenbm
Messages: 2
Registered: March 2006
Junior Member
When sending a email using utl_mail.send using our smtp server, the email message shows up with the To: and From: fields looking like the following:
From: =?UTF-8?Q?me@w4.byuh.edu?=
To: =?UTF-8?Q?aughenbm@byuh.edu?=
instead of just me@w4.byuh.edu and aughenbm@byuh.edu
Any ideas why emails are showing up this way?
The subject, date, body all look ok. Just the to and from lines look messed. I've tried two different smtp servers with the same effect.

The actually routine I run in sqlplus is:
SQL> BEGIN
2 UTL_MAIL.send(sender => 'me@w4.byuh.edu',
3 recipients => 'aughenbm@byuh.edu',
4 subject => 'Test',
5 message => 'If you got this message it worked!');
6 end;
7 /

It works but it is sure ugly. Any ideas?

Mark Aughenbaugh
aughenbm@byuh.edu
Re: utl_mail.send to/from format/appearance [message #184967 is a reply to message #184948] Sat, 29 July 2006 03:15 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Lookup Metalink note Note:295531.1: UTL_MAIL Adds The Characterset String To The Subject , Sender And Recipient

"Contact Oracle Support to require the patch for bug 4047618".
Previous Topic: Insert multiple rows
Next Topic: email no content
Goto Forum:
  


Current Time: Fri Dec 06 02:41:12 CST 2024