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

Example24.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.