WRITE_DATA

The WRITE_DATA procedure is used to send the text content of an email message and can be called multiple times to append data to the email.

Syntax

UTL_SMTP.WRITE_DATA (
   c     IN OUT NOCOPY connection, 
   data  IN VARCHAR2 CHARACTER SET ANY_CS);

Parameters

Considerations

• OPEN_DATA, WRITE_DATA, WRITE_RAW_DATA, and CLOSE_DATA must be called in that order. OPEN_DATA sends the DATA command to declare the start of sending the email content. After that, you can call WRITE_DATA and WRITE_RAW_DATA multiple times to send the email body. Finally, CLOSE_DATA sends the terminating character to end the sending.
• The application must ensure that the text content complies with the MIME (RFC822) specification. Use <CR><LF>.<CR><LF> as the terminating message. The <CR><LF>.<CR><LF> in the text content will be translated to <CR><LF>..<CR><LF>.
• Text (varchar2) data will be converted to the US7ASCII character set before being sent. If the text contains multi-byte characters, each multi-byte character that cannot be represented in US7ASCII will be converted to the ? character.
• If the ehlo command and smtp server negotiate the 8BITMIME extension, you can use the utl_raw package to convert the text to raw data and then send it using write_raw_data.