How I can increase size of message UTL_MAIL I need to send more than 10,000 characters [message #609530] |
Sun, 09 March 2014 09:29 |
|
arhaan
Messages: 5 Registered: March 2014 Location: MALAYSIA
|
Junior Member |
|
|
Dear friends,
please let me know how I can increase size of message UTL_MAIL
I need to send more than 10,000 characters??
PROCEDURE send(sender IN VARCHAR2 CHARACTER SET ANY_CS,
recipients IN VARCHAR2 CHARACTER SET ANY_CS,
cc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL,
bcc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL,
subject IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL,
message IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL,
mime_type IN VARCHAR2 CHARACTER SET ANY_CS
DEFAULT 'text/plain; charset=us-ascii',
priority IN PLS_INTEGER DEFAULT 3);
Thanks in Advance...
|
|
|
|
|
|
|
Re: How I can increase size of message UTL_MAIL I need to send more than 10,000 characters [message #609683 is a reply to message #609631] |
Tue, 11 March 2014 03:43 |
|
vslabs
Messages: 26 Registered: March 2014 Location: Cape Town
|
Junior Member |
|
|
Bluntly put. UTL_MAIL is a piece of smelly brown stuff. It does not support attachments larger than 32KB (as it uses PL/SQL strings that cannot exceed 32KB). It is also written using GoTo statements - an epic fail in my view.
You need to use UTL_SMTP directly. Manually format the e-mail contents and attachments as per MIME specifications. It is not that difficult. Remember to base64 encode binary attachments.
Back with Oracle 9i, there was a maildemo example from Oracle, that used UTL_SMTP and demonstrated the basics fairly well. There are also numerous source code examples using UTL_SMTP on the web - and examples of MIME formatting you can easily create and examine using your own mail reader.
|
|
|