Name
mime_body — used to compose multipart/mixed MIME message body
Synopsis
varchar
mime_body
(
|
in
mime_parts
any
); |
Description
The
mime_body()
procedure is used to compose a
multipart/mixed MIME body. it takes only one parameter, mime_parts, an array of
mime_part
elements such as those
produced by the
mime_part()
function.
Parameters
mime_parts
Array of mime parts such as those produced by the
mime_part()
function.
Return Types
The function returns a multipart mixed MIME body as text.
Examples
Example 24.217. Creating a MIME message body
This example will show the output in ISQL of producing a two part MIME message using the mime_body() and mime_part() functions.
SQL> select MIME_BODY (vector (MIME_PART (null,null,null,'this is a first'), MIME_PART (null,null,'base64','this is a second'))); callret VARCHAR _______________________________________________________________________________ Date: Tue, 25 Jun 2002 11:13:05 GMT Content-Type: multipart/mixed; boundary="----43c7f8b88e14a87dc3f2d840db93c731" Mime-Version: 1.0 X-Mailer: Virtuoso This is a multi-part message in MIME format. ------43c7f8b88e14a87dc3f2d840db93c731 Content-Type: text/plain Content-Transfer-Encoding: 8bit this is a first ------43c7f8b88e14a87dc3f2d840db93c731 Content-Type: text/plain Content-Transfer-Encoding: base64 dGhpcyBpcyBhIHNlY29uZA== ------43c7f8b88e14a87dc3f2d840db93c731-- 1 Rows. -- 21 msec.