Max. size of message body when using utl_mail.send
HUDec 5 2011 — edited Dec 13 2011I am looking for documentation on the subject, but so far unsuccessful.
Looking at the interface, I would expect the max. size to be 32kb (varchar2 in Pl/Sql),
and when sending ascii using the default mime_type ('text/plain; charset=us-ascii'),
I can send almost that amount.
However when sending utf8 using the mime_type 'text/plain;charset=UTF-8',
I can send approx. 7970 characters / 12650 bytes before I start getting errors
(ORA-06502: PL/SQL: numeric or value error: raw variable length too long)
While this exceeds my current needs, I would like to avoid having to test this on all the versions,
the customers might be going to use.
The above testes were done on:
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production running on windows.
The database character set is AL32UTF8